AD 94-05-05 R1
Registered aircraft · 26,232
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.
N724CTWarner David A · Carbondale, ILN724LCDixon Jody S · Chancellor, ALN724MCSutton Aircraft Salvage LLC · Palmer, AKN724TJPellow James A · Dixie, WAN72507Brown Elijah E · Chino Valley, AZN72512Jeffrey Mark D · Clayton, MIN72513International Air Services Inc Trustee · Carson City, NVN72514Mcintosh Douglas R · Wenatchee, WAN72515Lingo John C · Hamilton, INN72516Schwalm Wylie H · Spearfish, SDN7251AHoward F Bret · Albany, OHN7251MSkoglun Jon E · Cashmere, WAN7251XCampbell Jennings R Jr · Bell, FLN72526Perry James R · Simpsonville, SCN72529Kreit Kenneth S · Catlett, VAN7252ABarbaro Aaron J · Marcellus, NYN7252MFoxglove Melanie Ann · Captain Cook, HIN72530Rutschow Kenneth T · La Vergne, TNN72531Voltz Kyle D · Oshkosh, WIN72533Hale Thomas A · Springfield, OHN72536Sutton Aircraft Salvage LLC · Palmer, AKN72540Thomas Robert S · San Diego, CAN72544Fontenot Rickey D · Ville Platte, LAN72545Ejr Aviation LLC · Ashburn, VAN72547Manifee Doris Darlene · Black Canyon City, AZN72548Bronge Adam M · Ballwin, MON72549Windsock Capital LLC · Bertram, TXN7254AStiffey Jason J · Port Orchard, WAN7254SNickels Robert D · Fayetteville, TNN72552Johnson Aviation & Restoration LLC · Jacksonville, FLN72556Mccutcheon Claude C · Fort Worth, TXN72558Crunp Wyatt J · Wasilla, AKN7255ANunziato Anthony J · Tewksbury, MAN7255MLdg Aviation LLC · Carefree, AZN72560Jerkins Marvin Q · Coffee Springs, ALN72562Planes & Parts Inc · Weston, FLN72563Prox Dennis W · Port Orange, FLN72564Hallett Mark R · Hobe Sound, FLN72565Latrobe Tail Draggers Inc · Greensburg, PAN72568Miller Alan K · Scotia, NYN72569Bogart Sean A · Anchorage, AKN72570Mori Glenn E · West Ossipee, NHN72572Barnes Brett · Jacksonville, FLN7257AJones William Shane · Griffin, GAN7257MParker Charles B · North Pole, AKN7257SFidalgo Flyers LLC · Anacortes, WAN7257XBuckelew James E · Gulf Breeze, FLN72585Bean David J · Miami, TXN7258ANguyen Anthony V · Keyser, WVN7258HCrow Island Aero LLC · Stow, MA
Back to AD 94-05-05 R1