AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
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:79-10-14-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') 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.
N96491Registered aircraftN96493Smtm Holdings Inc · Wilmington, DEN9649APuls Kurt V · Valparaiso, INN9649BGoebel Christian E · Luray, VAN9649GAllen Todd N · Mccall, IDN9649VLagorce Victor X · Owasso, OKN9649XRp Aviation LLC · Plattsmouth, NEN964AAFlorida Flight Training Center Inc · Venice, FLN964AC63 Victor LLC · Fremont, OHN964AFBoerner Robert L Trustee · El Cajon, CAN964AUAuburn University · Auburn University, ALN964CPCivil Air Patrol · Maxwell Afb, ALN964EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN964LTUniversity Of La System DBA · Ruston, LAN964MSMount San Antonio College · Walnut, CAN964SPDirty Side Down Aviation LLC · Georgetown, TXN964TMByrd Properties LLC · Olathe, KSN964WFTempietto Inc · Aptos, CAN96500Granado Jose Jr · Chandler, AZN96503Miravete Paul Trustee · Saint George, UTN96505Price James Wilson · Big Stone Gap, VAN96509Aircraft Equities Inc · Wilmington, DEN9650AGraber Kirby D · Brooksville, MSN9650QVon Graff Kurt · Pennington, NJN9650VPittman Michael Sr · Chandler, AZN9650XJorsey Elizabeth A · Reidsville, NCN96510T34b LLC · Seattle, WAN96515Harrill David H · Charlotte, NCN96516Quanz Bernard A · Wayland, NYN9651AMarty Air LLC · Vero Beach, FLN9651MGrant Aviation Inc · Anchorage, AKN9651VHussain Mahmoud Taimour Said · Miami, FLN96524Kddt LLC · Meeker, CON9652VBrown Keno · Athens, TXN96531Goldeneye Air LLC · Orange, CAN9653BSd Office Supplies & Furniture Rentals LLC · Chula Vista, CAN9653QMikeska Rudy L · Taylor, TXN9653XSchuman Karl A · Fort Worth, TXN9654ARegistered aircraftN9654BDonohue Andrew · Tulsa, OKN9654QFly Pioneer Valley LLC · Gill, MAN9654VN9654v LLC · Lakeland, FLN96551Brentco Aerial Patrol Inc · Canton, OHN9655GMiddle Fork Aviation Inc · Challis, IDN96567Gmt Aviation LLC · Newtown, CTN96568Herman Quiroga · Phoenix, AZN9656AKriley Kevin · Smith Center, KSN9656QMccort Daniel R · Pensacola, FLN9656XCivil Air Patrol Inc · Maxwell Afb, ALN96573Condor Aero Club Inc · Zelienople, PA
Back to AD 79-10-14 R1