AD 72-03-03 R3
Registered aircraft · 17,027
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:72-03-03-R3')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
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:72-03-03-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') 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.
N16128Marquette County Flying Club · Marquette, MIN16129Rankin Kevin · Maryville, MON16134Adibi Saeed · Huntsville, ALN16137Hines Roger E · Greenville, OHN1613FAde William Henry III Trustee · Tucson, AZN1613HHampton William R · Marietta, GAFirst renewal noticeN1614FMathena Chad R · Narrows, VAN1615FWells Edmund B · Austin, MNN16165Registered aircraftN16166Hayden Scott M · Walworth, WIN16169Trotter Patrick J · North Las Vegas, NVN1616FMarciel John L · John Day, ORN1616HMayworm Jeffrey A · Ocala, FLN1616QKrehbiel Bradley C · Lake City, MNN16174Cirrostrats Inc · Deland, FLN16177Norby Aviation LLC · Hopkinton, MAN16179Farrell Donald A · Owasso, OKN1617HFlying Cloud Cherokees Inc · Chanhassen, MNN1617QAljanabi Mohammed Khalid · Herndon, VAN16180Last Mango Air LLC · Fond Du Lac, WIN16184Finkel David M · Shelbyville, INN16185Schwartz David W · Windsor, NYN1618FCastillo Giovanny G · Brodheadsville, PAN1618HMemrick Paul · Cedar Park, TXN16194Booth Jesse R · Alamosa, CON16196Macdonald Kaitlyn A · Dillon, MTN16199Allbritton John Mark Trustee · Oakland, TNN1619FReeve Howard E · Minot, NDN1619QAmos Carl R · Chandler, INN16202Steward Charles M · Tuttle, OKN16206Schultz Aviation Services LLC · Crowley, LAN16207Martinez Jose Antonio · Orlando, FLN16210Simpson Dean H · Limon, CON16216Scott Jeffrey A · Camden, TNN1621FDimtroff John P · Issaquah, WAN1621HDavis Vance · Del Valle, TXN16221Aero Maintenance Inc · Vancouver, WAN16222Thumser Douglas Francis · Newcastle, CAN16223Flyhnz LLC · Oxford, NCN16225Tumminaro Michael · Neodesha, KSN1622FN1622f LLC · Grand Prairie, TXN1622HSweeney Kay M · Kirkland, WAN1622QSchweim Robert J · Ocean City, NJN16238Hayes Lance Garett · Opelousas, LAN1623FVilvens Justin T · Granville, OHN1623QHigh Exposure Inc · Wilmington, DEN16243Como Jerry Wayne · Murfreesboro, TNN1624FPruitt Leonard E · The Colony, TXN1625QRegistration Pending · Powell, TNRegistration pendingN1626FDelgadillo Jose M · League City, TX
Back to AD 72-03-03 R3