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.
N4225VSell Scott F · Moody, TXN42265Clements Shirley R · Fruita, CON4226EButler Jeffrey C · Abilene, TXN4226LMcpherson Charles C III · Delhi, LAN4226UKane Gabriel · Yucaipa, CAN42274Graves Philip A · Fairfax, MON42277Quigley James J · Labelle, FLN4227LJohnson Wayne · Broken Arrow, OKN4227VRegistered aircraftN4228FLangland Llewellyn D · Sarona, WIN4229FRoss Sam M · Pioneer, LAN4229NAero-Mobil Inc · Wilmington, DEN4229VMorris Christopher Lee Trustee · Mabank, TXN422CVInternational Air Services Inc Trustee · Carson City, NVN422RGGerwig Ellen W · Anderson, SCN42301Steele William J · Lawrenceburg, INN4230FBiffle Sam E · Midland, TXN42318Turner Sarah Payson · Hickory Corners, MIN4231EVick Karl A · Elko, MNN4231FYancey Emron A · Sterling, AKN4231LSeaplanes R Fun Inc · Moneta, VAN4231NMcintosh Doughlas R · Clarksville, TNN4232EFicklin Robert J · Fairbury, ILN4232NJohnson Stephen G · Salisbury, NCN4232USterling John A · Port Lavaca, TXN4232VBishop John · Annapolis, MDN4233FSilverman James R · Superior, MTN4233LTulsa Technology Center School District No 18 · Tulsa, OKN42344Beck Doug · Bloomington, MNN4234UWasson Tina A · Lakeport, CAN42351Clark Thomas L · Port Orange, FLN4235FCastle Nial K III · Bonner Springs, KSN4235LReiter Trevor D · Minot, NDN4235UCottrell Mark C · Leitchfield, KYN4236LPierce Russell A · San Antonio, TXN4236NThornburg Timothy W · Union City, INN4236VSpitler John E · Laramie, WYN4237EMoffet Donald D · Barney, NDN4237FScherr Steven J · Mandan, NDN4237UMark & Debbe Inc DBA · Kalispell, MTN42384Rice Robert T · Trout Creek, MTN4238ELeake Larry W · Crookston, MNN4238VHamann David L · Los Lunas, NMN4239FDitmars William R · Redding, CAN4239NWatosky Ian F · Wolcott, NYN4239UStowell Thomas W · Gainesville, GAN423LFChirtea John · Milton, DEN42407Mccue Gregory P · Cody, WYN42408Sullivan Robert Jr · Downey, CARegistration revokedN4240NBennett Bob · Greenville, WI
Back to AD 94-05-05 R1