AD 94-05-05 R1
Registered aircraft · 26,230
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.
N90691Jewett Dixie Lee · Dayton, ORFirst renewal noticeN90698Thiel David W · Independence, ORN9069BDemello Michael B · Phoenix, ORN906SGGervae Daniel J · Iron River, MIN9070AKerr Colleen A · Waukesha, WIN9070BDavis Hunter R · Morgan, TXN9071BLaney Kevin D · Maiden, NCN9072CBerg Michael S · Eleva, WIN9074BWasik Marvin B · Hernando, FLN9075AKingdom Air Corps · Sutton, AKN9075BLaney Charles A · Maiden, NCN9076AList Oliver · Wasilla, AKN9076BBcm Consulting Inc · Wilmington, DEN9077ADay Jeffrey R · Haslet, TXN9077BMcdaniel Terry · Gig Harbor, WAN9079AMandere Mark Edward · Spokane Valley, WAN907DCBrian Murray J · Pekin, ILN907TCDavis Randal V · Juneau, AKN9080BAirline Pilot'S Historical Society · St Charles, ILN9081BCoulter Ronald F · Brownsville, ORN9083AStorch Shaidon P · Deer Park, WAN9084BDorn Kevin J · De Pere, WIN9084CDuncan Jeremy D · Kingsport, TNN9085BMccallister Nicole Kathleen · Wasilla, AKN9086ATaylor Scott G · Draper, UTN9088ACox-Kuss Sarah Ann · Colorado City, TXN9088BRindler Michael · Apalachicola, FLN9091ARutan Aircraft Flying Experience · Waller, TXN9092BBoatright Michael L · Live Oak, FLN9092DWilliams Wendell B · Anchorage, AKN9093BAgri Flite Services Inc · Wakarusa, INN9093CGofly LLC · Salem, NHN9093DYaryan Kevin R · Connersville, INN9094BKirby Bob O · Moreno Valley, CAN90951Simard Maurice E · Windham, CTN9095DBig Dog Aviation LLC · Anchorage, AKN9096BAtkins Steven D · Valley Head, ALN9096LBanks Mark V · Jamestown, CAN9097AWard Daniel Wayne · Boonville, NCN9097BIrvine Paul E · Antioch, CAN9097DEllingson Leslie B · Harwood, NDN9098AWestphal Keith H · Mazomanie, WIN9098CPritchett Flying Service LLC · Rolla, MON9099BLazzaro Michael · Santa Clarita, CAN909APHorton Jeffrey T · Winter Haven, FLN909JJWeeks Kermit A · Polk City, FLN909MRRipp Patrick L · Mineral Point, WIN909UNNiederkorn Richard · Galesville, WIN90CMKing James A · Hines, ORN90DGMontrose Regional Airport · Montrose, CO
Back to AD 94-05-05 R1