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.
N4874EJenkins Don C · Wymore, NEN4876MJones Derick · Moultonborough, NHN4877MHorton Thomas James · Salem, WIN4878EPoklar Norman A · Mount Orab, OHN4878HParkes Kenneth J · Middleburgh, NYN487DCFleming Michael P · Newberg, ORN487MTGilmore Bobby Keith · Swifton, ARN487XACrafa Steven J · Golden, CON4880MAlarado Aviation LLC · Chugiak, AKN4881HGbq LLC · New Prague, MNN4884EPeck James M · Harrisburg, ARN4885MRiggin Flight Service Inc · Madison, SDN4887EHicks J E · Opa Locka, FLRevoked, canceledN4888MKissenger Richard G · Centre Hall, PAN488BBJ&J Aero · Chuckey, TNN488EMBishop Patrick M · Reading, MAN488WMMackey Ken G · Ridgeville, SCN4891MRich Jeffrey P · Graham, NCN4897MCauv LLC · Cincinnati, OHN4898EHagler Thomas J · Paradise, CAN4898MWarren Spencer T · Fritz Creek, AKN489ECRobertson James T · Forest Lake, MNN489EZWarnock Tony J · Mobile, ALN48DTThurnau Daniel E · Kingston, ILN48DWYearwood Neva D · Mineola, TXN48EStransky Theodore J · Newburgh, INN48EJBuchholz Mark A · Saint Louis, MON48FACavu Pilot LLC · Powell, TNN48KJMoroni Leonardo A · Orlando, FLN48LMKruse Paul G · Queen Creek, AZN48TFFreeman Stephen K · Bartlett, TNN48TYNeal Alan B · Cherry Valley, CAN48WHElsea Incorporated · Circleville, OHN49015Stewart Dan R · Cashmere, WAN4901HSchwend Brian · Forsyth, MTN4902VZweifel John M · Beresford, SDN4905MHill Andrew J Trustee · Benton, MON4909MAnte George S · Eagle River, AKN490DCWulff John D · Hayward, WIN4910HScott Lonnie L · Nikiski, AKN4911HBryn Jamie P · Dazey, NDN4913HCascavilla Philip J · Dallas, TXN4916HConnell James L · Bushnell, FLN491WTHogan James R · Bartlesville, OKN4920HHaak Michael Dane · Portland, ORN4923HNormandeau Daniel R · Thompson Falls, MTN4924MEdwards Wesley E · Hettinger, NDN49251Weller Steven C · Hummelstown, PAN4926HBerry Kevin G · Oakville, WAN4926MBevis Thomas L · Sebring, FL
Back to AD 94-05-05 R1