AD 94-05-05 R1
Registered aircraft · 26,231
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N3615LEynon Thomas Elliott · North Royalton, OHN3615SBlacqjacq Aviation Co · Wilmington, DEN3616JB&R Aircraft LLC · Wadsworth, OHN3616LSoflair Aviation Solutions LLC · Miami, FLN3616SArtisan Outreach LLC · Dunnellon, FLN3616THam Russell W · Dike, TXN3616VSemler Greg · Guthrie, OKN3617Arend Jack H · Tonopah, AZN3617JShowalter Steven L · Goshen, INN3617TRegistration Pending · Fairbanks, AKRegistration pendingN3618HEricson Eric · St Charles, ILN3618JWright David G · Lake Oswego, ORN3618VPudik James N · Metamora, ILN3619SFitch Aviation Holdings LLC · Pottsboro, TXN3619VHardesty Jerry L · Terrebonne, ORN361CCSackman Robert B · Unionville, INN361RHDerdak Stephen · San Antonio, TXN361XSorley Steven J · Roy, UTN3620JBerens Eric A · Stevens Point, WIN3620LMullins Lawrence D · Germantown, OHN3620SBoese Howard · Brownell, KSN3621ECombs Ryan D · Shawnee, KSN3621JLow Cost Flying LLC · Chandler, AZN3621SAlletto Alexander J · Russell Springs, KYN3622LStrelzik Raymond W · Hatfield, PAN3622SMichael Lewis R · Big Rapids, MIN3622VFox John E · Boonville, CAN3623NSyverson Michael B · Waubun, MNN3623VClark Cecil L · Shreveport, LAN36241Chaplin Leeak Jaybird · Port Alsworth, AKN3624VWiens Patrick B · Houston, TXN3625LWilliams Michael R · Gig Harbor, WAN3626HPost Greg G · Mapleton, KSFirst renewal noticeN3626JEa Cvg LLC · Erlanger, KYN3626LKoshar Robert E · Watervliet, MIN3626VTorres Torres Angel G · Chesapeake, VAN3627KMccasland Jerry E · Orland, CAN3627LGeorge Edward J · Highland Village, TXN3628JLucarelli David L · Moncks Corner, SCN3628KHewitt Michael D · Lake Havasu City, AZN3628LThrasher Gary Phillip · Galena, OHN3628SWright Way Air Venture LLC · Westville, INN3629SBradley Christopher J · Left Hand, WVN3629VHeitz John · Manvel, TXN362LKJackson Brian J · Anchorage, AKN3630SFly Dogs LLC · Sunbury, OHN3631LMcveigh Ian T · Mansfield, TXN3631SJust Plane Fun 9m6 LLC · Lake Providence, LAN3631VFisher Air LLC · Cardington, OHN3632JMitterling Richard H · Boothbay Harbor, ME
Back to AD 94-05-05 R1