AD 2002-09-12
Registered aircraft · 281
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2002-09-12')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-09-12')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2002-09-12') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-09-12') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N200UOhio University · Albany, OHN207PDale Aviation · Rapid City, SDN20FDGilmer Aircraft Leasing LLC · Wilmington, DEN219JGInternational Jet Aviation Services Inc · Centennial, CON224CCRanger Aviation LLC · Houston, TXN226BKAvtran LLC · Clayton, MON2297CRaviator II LLC · Dallas, TXN22MTHagler Air LLC · Augusta, GAN2354YUtah Department Of Transportation · Salt Lake City, UTN244HAHowell Air LLC · Dover, DEN246GTWestern Pilot Service Inc · Phoenix, AZN247MDLta Group Holdings LLC · Amarillo, TXN252RCPrestige Worldwide Flights Two LLC · Imperial, CAN25GRBarrosa LLC · Scottsbluff, NEN261GBSafford Aviation Service Inc · Coolidge, AZN266RDGuardian Flight LLC · Lewisville, TXN26ARDale Aviation · Rapid City, SDN275LARts Ventures LLC · San Antonio, TXN284MRDale Aviation Inc · Rapid City, SDN290NCMr Boo Properties LLC · Indianapolis, INN291DFRmb Leasing Inc · Dover, DEN299RPGuardian Flight LLC · Lewisville, TXN300AWDavis Aviation Inc DBA · Brandon, MSN3030GDutch Aviation LLC · Perry, IAN303CAM&H Flight Services LLC · Kerrville, TXN305ZAZulu Air LLC · Opa Locka, FLN3066WFortis Aircraft Leasing LLC · Reno, NVN308CSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN308MDGem City Properties LLC · Laramie, WYN30PJHighland Paving Co LLC · Eastover, NCN313DWDurair Inc · Key West, FLN314LMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN315RPPro Serve Aviation LLC · Englewood, CON316MDH&D Bluesky LLC · Kalispell, MTN319MBAircraft Holding Solutions LLC Trustee · Newark, DEN3216KSouth River Services LLC · Myrtle Beach, SCN3220LPee Dee Aviation LLC · Florence, SCN3221MGuardian Flight LLC · Lewisville, TXN322MRPf Aircraft LLC · Graham, TXN3246SInsync Investments LLC · Dover, DEN3262REaglemed LLC · Wichita, KSN3263CEaglemed LLC · Wichita, KSN3263NGuardian Flight LLC · Lewisville, TXN329GSAugusta Aviation Inc · Hilton Head Island, SCN32RHPor Aviation LLC · Huntersville, NCN330DBBlueskyways LLC · Bend, ORN333XPRichard L Richards Pa Trustee · Coral Gables, FLN342ERSoutheast Aviation LLC · Oxford, MSN354AVAev Aviation LLC · Hilton Head Island, SCN355PCEagles Wings Avaition LLC · Monroeville, AL
Back to AD 2002-09-12