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.
N5380QFoy Timothy D · Malvern, PAN5380TEdwards Air LLC · Raleigh, NCN5381Moore Matthew D · San Jose, CAN5381CBergman James H · Buckley, WAN5381QAirgo Inc · Centralia, ILN5382QMiller Charles L · Mooresville, NCN5383CJenkins David A · Gainesville, FLN5383QEight Three Quebec LLC · Arlington, VAN5383TMeyers Morgan J · Twin Falls, IDN5384CPrice Edsel B · Leesville, SCN5384RKidd Frank E Jr · Wilson, NCN5384TJohnson William R · Virginia Beach, VAN5386RVargo Michael D · Fremont, OHN5387ROancea Traian · Oakdale, CAN5387TMagnusson Charles D · Upper Sandusky, OHN5389CRegistration Pending · Niagara, WIRegistration pendingN5389RTetrault David E · Largo, FLN5389TChadwell Letch J · Hulbert, OKN538JBNelson Adam · Buckley, WAN538TBCorum Richard E Jr · Clemmons, NCN5390CGoebel Kendra S · Sarasota, FLN5390QIgnarro Jessie · Bay Shore, NYN5390RSmith James H · Fordyce, ARN5390TBakker Johanna · Spokane, WAN5391NClifford Eric S · Paris, TXN5391QMja Aviation LLC · Channahon, ILN5392CMcclintock Jesse H · Camarillo, CAN5392QLatitude Aviation LLC · Cedar Rapids, IAN5392TStarkovich James M · Arlington, WAN53932Boyle Joseph E · Hagerstown, MDN5393CPlane Fun Inc Tr Trustee · Snellville, GAN5394CWillie Gary D · Elkader, IAN5394TBigler Danny L · Owasso, OKN5395QOwens John C · Mount Carmel, PAN5396CSmith Richard E · Olympia, WAN5396RPrecocity Academy LLC · Gibsonia, PAN5396TMclaughlin Daniel J · Elbridge, NYN5397CFontana Andrew W · Lake City, MIN5398CRed Rose Flying Club · Spring City, TNN5398TSandstrom Mark · Minot, NDN539MTFlyboys LLC · Fall City, WAN53BWheaton James · Rutherfordton, NCN53EZLasley Russel · La Habra, CAN53FMHascall Michael L · Palmetto, FLN53JXVoligny Patrick E · Chillicothe, OHN53LDEnglish William · Fairfax, VAN53PHHaynes Jason Allen · Justin, TXN53WEEdson Robert Wayne · Hollister, MON5400TDonnelly Charles R · Nashua, NHN5401QMaine Center For Classic Aviation · Pittsfield, ME
Back to AD 94-05-05 R1