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.
N45398Tundra Wolf Inc · King Salmon, AKFirst renewal noticeN45407Westrup Gregory W · Greensburg, INN4540MBiloff Chet Allen · Palmer, AKN4541CPolsley Christopher · Galion, OHN4542CThomas Scott A · Groveland, CAN4542MHyrkas Thomas K · Calumet, MIN45430Coffield Alan B · Canyon Lake, CAN45434Urban Aviation Services Inc · Paxton, MAN4543CSkog Ken · Riverside, CAN4543MJoan Sunet Scutary · Umatilla, FLN45446Coronel Juan M · Elk Grove, CAN45449Beckett Michael O · Roy, WAN45454Aero Flight One LLC · Peoria, AZN4545EOchsenbauer David J · Ashland, WIN45463Burns Jeffery T · Independence, ORN45467Airnolimits LLC · Palm Coast, FLN4546CHoffman Gregory E · Fairbanks, AKN4546UHarrier Soaring Club Inc · Raleigh, NCN45471Verhoeven Mathew M · Avondale, AZN45473N2flyingaviation LLC · Foxworth, MSN45478Unertl Robert C · Columbus, WIN4547URegistered aircraftN-number assigned, not yet registeredN4548EAgaliotis Paul E · San Martin, CAN4548UHaan James J · Norton Shores, MIN45491Birdwin LLC · Buras, LAN4549CWatsons James W · Fairbanks, AKN4549MBoardman Thomas M · Greenwich, NYN4549UJmh Futures LLC · Gilbert, AZN454BBDurden Patrick G · Neshkoro, WIN454LELinden Thomas D · Mcfarland, WIN4550CBrown Larry A · Mesa, AZN4550HParris David Tevis · Virginia Beach, VAN4550MToth Frank L · Schenevus, NYN4550UGreene County Holdings LLC · Albany, NYN45510Hansen Albert C · Mojave, CAN45511Sb Aviation LLC · Gowanda, NYN45512Caponio & Sons Inc · San Francisco, CAN45520Frazier John C · Oxford, NCN4552CMckinney Lodging Management LLC · Trout Lake, WAN4552EHeppler James Scott · Yakima, WAN45530Young Thomas E Jr · Alton, MON45532Wall Craig M · San Antonio, TXN4553ESasinowski Vance J · Anchorage, AKN4553MClay Ernie · Huntington, WVN45541Zxtair LLC · Mankato, MNFirst renewal noticeN45542Baldridge Steven J · Edmonds, WAN4555CVan Roo Jon D · Hartland, WIN45560Johnson Adam · Denton, TXN45563Tremer Jesse · Kathleen, GAN45565Puzio Joseph E · Butler, TN
Back to AD 94-05-05 R1