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.
N93355Brunettin Mark · Frierson, LAN93358Rankins Todd E · Mohawk, NYN93369Taylor Raymond E · Oklahoma City, OKRegistration revokedN93389Lambert Brian L · Tahlequah, OKN933JSSchnurr Jack C · North Pole, AKN933PAerowood Aviation LLC · Monroe, NCN9340BCook Raymond L · Spring Grove, ILN9340UJohnson Cory D · Rugby, NDN93413Dodson Robert L · Ottawa, KSN9341BYager Keith E · Eugene, ORN93427Doerfler Linda J · East Amherst, NYN93439Thomas Hunter David · Riverton, ILN9343BBas Part Sales LLC · Greeley, CON9343ULazor Ronald E · Middlefield, CTN9344BSumners David O Jr · Eastville, VAN9344UNewman Thomas E · Saint Ignatius, MTN9345BPasquariello Thomas · Alton, NHN9346BHarter Wayne R Jr · Alliance, OHN9347UAirgo Inc · Centralia, ILN93499Muise Leroy · Trenton, MEN93503Rankovich Danny · Lehighton, PAN9350BHoman Ralph C · Weiser, IDN93511Tabbert Charles · Diamondhead, MSN9351UHolt James D · Greensboro, NCN9352DPanther Paul A · Montrose, CON93530Freeman Robert Dennis · Batavia, OHN93536Gregory Vernon L · Swansea, SCN93543Hawkins Terry D · Conyers, GAN9354BC2 Aero LLC · Dallas, TXN93553Poliak Mark A Trustee · Carmel, INN93555Hess John C · Islip Terrace, NYN9355ELurie Allan H · Peoria, ILN9356BWard Clayton D · Mcville, NDN93576Larson Daniel M · Fergus Falls, MNN9357UBaldwin James S · Sylvania, OHN9358USaddedine Nouredine · Frisco, TXN93593Jones Bruce B · Ukiah, CAN93597North Fergus Flying Club · Winifred, MTN93598Boehler Brian S · Pacific City, ORN9359BPalinsky Gary C · Au Gres, MIN935CBCalifornia Baptist University · Riverside, CAN93609Anderson Wilbur W · Diamond City, ARN9360BWallace Joseph R · Winchester, KYN9360UVeenker Frank C · Tygh Valley, ORN93611Vukonich Thomas P · Oxford, MIN9361BPazsint Joseph J · Wasilla, AKN93636Schneider Scott M · Tribune, KSN93655Brosman Earl H · Indianapolis, INN9365BPillar Mountain Airframes LLC · Palmer, AKN9365MFiglia Emanuele · Lewes, DE
Back to AD 94-05-05 R1