AD 95-07-03
Registered aircraft · 146
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:95-07-03')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-07-03')
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:95-07-03') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-07-03') 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.
N590AAFrontera Flight Holdings Inc · Dover, DEN595AAPac Blue Aerospace · Fairbanks, AKN615PA2d Aviation Corp · Frisco, TXN623RHOmega Air Inc · San Antonio, TXN624RHOmega Air Inc · San Antonio, TXN637SHPacific Aircorp 49741 Inc · San Francisco, CAFirst renewal noticeN67AUBank Of Utah Trustee · Salt Lake City, UTN697BJTexas Air And Space Museum Inc · Amarillo, TXN706PCOmega Air Inc · San Antonio, TXN707CAOmega Air Inc · San Antonio, TXN707MQAircraft Endeavors LLC · San Antonio, TXN708AAWorld Aviation Services LLC · Medley, FLN71KMBank Of Utah Trustee · Salt Lake City, UTN720CKKalitta Charters II LLC · Ypsilanti, MIN721MNBd Md-87 LLC · Longwood, FLN722LALogistic Air Inc · Reno, NVN724CKKalitta Charters II LLC · Ypsilanti, MIN726USUSA Jet Airlines Inc · Belleville, MIN727HLAviation Sales And Charter LLC · Dover, DEN727NKAntares Aviation LLC · Boca Raton, FLN727USUSA Jet Airlines Inc · Belleville, MIN727YKFayaka Airways LLC · San Francisco, CANon-citizen corporation, flight hours not reportedN729CKConair USA Co · Dover, DEN7520AAerothrust Holdings Leasing LLC · Miami, FLN752DHKalitta Charters II LLC · Ypsilanti, MIN7541AFrontera Flight Holdings Inc · Dover, DEN7548AFrontera Flight Holdings Inc · Dover, DEN7550Frontera Flight Holdings Inc · Dover, DEN782TWSierra American Corp · Wilmington, DEFirst renewal noticeN783TWSierra American Corp · Wilmington, DEN784TWSierra American Corp · Wilmington, DEN794AJZero Gravity Corp · Merritt Island, FLN801WACaribbean Sun Airlines Inc DBA · Miami, FLN802DHHeavylift Cargo Airlines Inc · Kingman, AZN803DHHeavylift Cargo Airlines Inc · Kingman, AZN804DHBjw Services Inc · Kingman, AZN805MLSmb Md-87 II LLC · Longwood, FLN806WA53251 LLC · Miami Springs, FLN807WAFederal Dynamics Corp · Henderson, NVN808WACaribbean Sun Airlines Inc · Miami, FLN813TLGeoairgroup LLC · Wilmington, DEN861GAWorld Atlantic Leasing LLC · Miami Springs, FLN872SJHeavylift Cargo Airlines Inc · Kingman, AZN874AAAntares Aviation LLC · Boca Raton, FLN883GAFalcon Commercial Aviation LLC · Miami, FLN887GARising Sun Aviation LLC · Irving, TXN904CETatonduk Outfitters Limited · Fairbanks, AKN9113DHeikkila Glenn R · Rockland, MAN918AVBank Of Utah Trustee · Salt Lake City, UTN91BUBank Of Utah Trustee · Salt Lake City, UT
Back to AD 95-07-03