AD 2001-07-11
Registered aircraft · 472
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:2001-07-11')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-07-11')
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:2001-07-11') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-07-11') 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.
N31TKLear 31 Partners LLC · Edwards, CON31YAInternational Trading Energy Fuels LLC · Houston, TXN31ZVEzair International Leasing And Management Inc · Wilmington, DEN322GC1mg LLC · Fort Wayne, INN322PRN322pr LLC · Scottsdale, AZN325NWKalitta Charters LLC · Ypsilanti, MIN329TJForsythe Aviation LLC · Point Lookout, MON32HHPhi Health LLC · Tempe, AZN32HMAir Mellon LLC · Wilmington, DEN32PAPhoenix Air Group Inc · Cartersville, GAN330LA-C Electric Co · Bakersfield, CAN331JAM K Rockwell Investments LLC · Fayetteville, ARN331JVBoulder Falcon LLC · Salt Lake City, UTN331USN331us LLC · Hillsboro, ORN335KBShelt William J · Denton, TXN335PRGy Aircraft LLC · Daytona Beach, FLN335RCN335 Aviation Corp · Middletown, DEN342JPDtm Aviation LLC · Statesboro, GAN351ACLuna Jet LLC · Hauula, HIN351ASRoyal Air Freight Inc · Waterford, MIN351PJPremier Jets Inc · Hillsboro, ORFirst renewal noticeN351TXDodson International Parts Inc · Rantoul, KSN352CKKalitta Charters LLC · Ypsilanti, MIN352EFDodson International Parts Inc · Rantoul, KSN352MDDolphin Aviation LLC · Tulsa, OKN352PJPremier Jets Inc · Hillsboro, ORN352PMEleven Eleven Holdings LLC · Middletown, DEN353CKKalitta Charters LLC · Ypsilanti, MIN354CKKalitta Charters LLC · Ypsilanti, MIN354LQBrunner Aerospace LLC · Georgetown, TXN355CKKalitta Charters LLC · Ypsilanti, MIN355KCN331us LLC · Hillsboro, ORN355RMLopez Fabio A · Denver, NCN355UALopez Fabio A · Denver, NCN357CKKalitta Charters LLC · Ypsilanti, MIN357LJJet Rescue USA Inc · Boca Raton, FLN358CKAirnet II LLC · Columbus, OHN359CKAirnet II LLC · Columbus, OHN35AEAmerican Fidelity Corp Trustee · Dover, DEN35AJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN35LJDelta Bravo LLC · Taylorville, ILN35WB253217 Corp · Sumas, WAN35WLKalitta Charters LLC · Ypsilanti, MIN361PJPremier Jets Inc · Hillsboro, ORN362PJPremier Jets Inc · Hillsboro, ORFirst renewal noticeN363PJPremier Jets Inc · Hillsboro, ORN364CLLacy Clay Trustee · Los Angeles, CAN365GLTms Jet 31 LLC · Wilmington, DEN367DAGlobal Aviation Inc · Hillsboro, ORN36BLGo Fast Aviation LLC · El Cajon, CA
Back to AD 2001-07-11