AD 2012-10-13
Registered aircraft · 13,306
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:2012-10-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:2012-10-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:2012-10-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:2012-10-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.
N305CDModern Industrial Services Inc · Beaumont, TXN305EPPickard Erik · Deer Park, TXN305JTWinniwolfe Holdings LLC · Wolfeboro, NHN305LWProfessional Flyers Corp · Wilmington, DEN305MHartley John · Kissimmee, FLN305MMSegal Marshall B · Chicago, ILN305PFSale Reported · Crystal, MNSale reportedN305PJBradley Alana J · Joliet, ILN305RPMiami Romeu Papa LLC · Miami Beach, FLN305VVPeeled Egg Aviation LLC · Santa DomingoN3063WReich Michael A · Woodside, CAN30644Registered aircraftN3066DN3066d LLC · Pompano Beach, FLN306CDDesantis Michael J · Port Orange, FLN306CPFe Xy LLC · Leesburg, VAN306DCEngeman Charles E · Charlotte, NCN306PMBc 414 LLC · Vineyard Haven, MAN306RSCorsair Aviation Holdings LLC · Orange Park, FLN306SRElevate Air Service LLC · Montrose, CON306STKruljiac Jonathan Wade · Kenmore, WAN306TBApex Aviation Holding LLC · Kalispell, MTN3070TJacobson Jeffery L · Manning, NDN3074JMehling Robert C · Hardin, MTN3075PWjs Inc · Greeneville, TNN3075XOrthoredlands Leasing LLC · Redlands, CAFirst renewal noticeN30771Dodson International Parts Inc · Rantoul, KSN30774Stucco Supply Co Of San Jose Inc · San Jose, CAN30777Huff Charles Christopher · Midland, TXN3077ZBravo Air LLC · Troy, MIN30787Jetsons Holdings LLC · Birmingham, ALN3078YDodson International Parts Inc · Rantoul, KSN3079WFerr Air Ltd · Southampton, PAN307AHadaway Phillip Allen · Hooks, TXN307CDBarton Michael · Creve Coeur, MON307CPCirrus R50 LLC · Shreveport, LAN307HYWallace Richard Ronald · Santa Teresa, NMN307JRSatellite Radio Management Inc · Hays, KSN307JSPittard Kirk L · Grapevine, TXN307NRAeromac II LLC · Gillette, WYN307PMRegistered aircraftN307TTCharter Place LLC · Jackson, WYN3080KSnuggs Ronald S · Driggs, IDN30813T L Irrigation · Hastings, NEN3083HSalters Flying LLC · South Dartmouth, MAN3084MSouthern Aircraft Consultancy Inc Trustee · Casper, WYN3084ZMather Clay · Orange Beach, ALN3085FA To Z Endeavors LLC · Leawood, KSN3085KBennett Ross G · Eustis, FLN3086KRicotta Tom · Yuma, AZN3088DAquasol Corp · Rock Hill, SC
Back to AD 2012-10-13