AD 75-08-03
Registered aircraft · 10,858
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:75-08-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:75-08-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:75-08-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:75-08-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.
N1427XAlis Aquilae LLC · Opelika, ALN1428JLeedham James E DBA · Mazeppa, MNN1429XRegistered aircraftN142ASGray William Colin · Seattle, WAN142MHAerospace Trust Management LLC Trustee · Wilmington, DEN1430XRuggiero Matthew J · New York, NYN1432TSmith David · Belleville, ILN1433TTilton Dave P · Bradyville, TNN1433XEchota Flyers Inc · Calhoun, GAN1434TStrickland Jason · Gulfport, FLN1437TBenazzi Wahiba · Frisco, TXN1439XDovy Aviation LLC · Houston, TXN143BSMoses Charles · West Friendship, MDN143EYTriple D Aviation LLC · Merritt Island, FLN143JMMa Cedric Sek-Kong · Los Angeles, CAN1442TKeller Mark · Alexandria, KYN1444XWaddell Charles · Elk Grove, CAN1445TWhelan And Sons Realty LLC · Suffield, CTN1446XN15956 Inc · Wilmington, DEN1447HMarkovich David E · Eden Prairie, MNN1447TDa Silva Paulo E · Orlando, FLN1447XGaventa Edward J · Logan Twp, NJN1448XMallett Robert T · Wilmington, MAN144MC450 Dancer LLC · Benton Harbor, MIN1450RSammy Shwan · Danvers, MAN1450TBruce James E · Prattville, ALN1454XPetrak Richard A · Hunker, PAN1455XAviation Capital Management LLC · San Jose, CAN1456XYoung Daniel J · Cedarburg, WIN1460XSimpson Arthur Lee · Richland Center, WIN1461TNiepert William · Jacksonville, NCN1462TWilliams Lesley J · Marquette, MIN1462XVerbsky Douglas Collins · Frisco, TXN1463TN1463t LLC · Oak Hill, VAN1464TSiedentopf Zyurelaie Indiana · Yelm, WAN1464XSymmetry Inc · Sarasota, FLN1467TThree2tango LLC · Mount Pleasant, SCN1468THindle John Charles IV · Whitehouse Station, NJN1469TThree Wing Flight School LLC · Stratford, CTN146JWDodge Inc · Wilmington, DEN1471TFranks James Charles · Conroe, TXN1471XSale Reported · Epworth, GASale reportedN1472TGreen Lakes Aviation LLC · Belton, SCN1474XKjeldsen Frederik C M · Poughkeepsie, NYN1476TBough Jayce K · El Dorado Hills, CAN1476XAbel Adam T · Aberdeen, OHN1477TSrh Club Inc · Wilmington, DEN1477XRed Rock Flying School LLC · Mesa, AZN1478XMello Edward R Jr · Land O Lakes, FLN1479TWnc Aviation LLC · Arden, NC
Back to AD 75-08-03