AD 95-09-13
Registered aircraft · 1,061
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-09-13')
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-09-13')
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-09-13') 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-09-13') 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.
N335CMPura Plastic Surgery LLC · Doral, FLN33MHAkeyson Edward W · Durham, CTN33UWPadf LLC · Fort Collins, CON33WVInarayan Inc · Winter Park, FLN341RBRomeo Bravo LLC · Thompson, MON342RCHyland'S Pharmacy LLC · Wheeler, TXN344TCInternational Air Services Inc Trustee · Carson City, NVN346CHAce Flight Center Inc · St Thomas, VIN3479VInternational Air Services Inc Trustee · Carson City, NVN347ABTropical Transport Services Ltd Inc · San Juan, PRN34ADPremiere Aviation Inc · Concord, CAN34AGJ D Aviation Leasing LLC · Mundelein, ILN350GMCannonball Trucking Inc · Houston, TXN351ABTropical Transport Services Ltd · San Juan, PRN351HCBig Elk Aviation LLC · Elk City, OKN365FDci Air LLC · Dodge City, KSN366MN366m LLC · Dover, DEN366MCHastings Steve T · Corpus Christi, TXN36887Aa Aircraft Adventure LLC · Joplin, MON36908Williams D Eric · Palm Springs, FLN36911Hyannis Air Service Inc · Hyannis, MAN36961Alpha 414a LLC · New Smyrna Beach, FLN369RKKrum Force 1 LLC · Wichita, KSN369RMRothschild Jonathan Trustee · Tucson, AZN37127Richland Aviation Inc · Sidney, MTN37181Jrs Aviation LLC · Falls City, NEN371SBN333bc LLC · Franktown, CON37404Bear Giant LLC · Eden Prairie, MNN37417Registered aircraftN37424Flight Development LLC · Wichita, KSN37475N37475 Management LLC · Las Vegas, NVN37478Ghareeb Enterprises Inc · Charleston, WVN37543Construction Solutions & Consulting LLC · Sedalia, MON375KCGuittard Chocolate Holdings Co · Burlingame, CAN375RHyannis Air Service Inc DBA · Hyannis, MAN377JMSanchez Joshua A · Bosque, NMN378KAga Aviation LLC · Lewes, DEN379TWTanglewood Aviation LLC · Fort Mill, SCN37FSLuxury Transportation LLC · Talladega, ALN37RZOwens Martin · Telluride, CON37UJet Set Aircraft Inc · Van Nuys, CAN382BWWd Aviation Group Inc · Atlanta, GAN382CRSkyport Aviation LLC · Oxford, MIN385CAHyannis Air Service Inc · Hyannis, MAN38CJAirplane Seven LLC · Watkins, CON38GJMonahan Jeffrey L Trustee · Long Beach, CAN3908CMccreery Aviation Co Inc · Mcallen, TXN3920CN3920c Lc · Wichita, KSN3922CN3922c LLC · Dover, DEN3923CSwope Aviation LLC · Elizabethtown, KY
Back to AD 95-09-13