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.
N9685AVarvayanis Mark · Dryden, NYN96861Mizer James D · Hailey, IDFirst renewal noticeN9687AHolbrook James A · Burnet, TXN9688ASmith Herschel C III · Panama City, FLN968CT968ct Aircraft Leasing LLC · Spanish Fork, UTN968SWLessor Mark E · Boise, IDN9691ABernette Allan E · Wisconsin Rapids, WIN9694AOgilvie Adam P · Loveland, CON9696ABingham John R · Leawood, KSN96970Harbison Seward W · Delta Junction, AKN969DJJohnson David C · Raleigh, NCN96BJCrain James Bruce · Enid, OKN96JSchmitz Patrick A · Wynot, NEN96LCDomich Jeffrey E · Petaluma, CAN96LHFfrench Lawrence R Jr · Austin, TXN96RRDocter David Alan · New Braunfels, TXN96SRFuts Enterprises LLC · Anchorage, AKN9702TStricklin Lance A · Fort Greely, AKN9703APease Matthew · Belgrade, MEN9703TBlock Douglas · Pearl City, ILN9706TStoddard Micah J · Boise, IDN9706ZGroenewegen Bruce C · Snohomish, WAN9709AMckibbon Paul Lee · Millsap, TXN9710TTrzynka Dean A · Iron River, WIN9713ARueckl Randall L · Hortonville, WIN9714AReinoehl Gregg A · Reelsville, INN9715AGarry L Lewis · Livingston, LAN9718FGay George M · Cordele, GAN971AAHobgood David · Bartow, FLN971DHaley Robert Jay · Livermore, CAN9721NGmk Aviation LLC · Brighton, MIN9722TFoust Richard W · Minneapolis, KSN9723TLuinstra Lee Vernon · Benton, KSN9725TAnderas Per R · Green Bay, WIN9726HHarbaugh Scott A · Belle Valley, OHN9726TBuettner Casey R · Kearney, NEN9727ACaughlin David Drew · Boise, IDN9727TRogers Bob · Mountain Green, UTN9728ADailey Brian A · Strongsville, OHN9728TBanks Trevor A · Thomaston, GAN9729ABaker Benjamin D · Catasauqua, PAN9729TGibbs David F · Greenville, NCN972MAAir Repair Inc · Easton, MDN9731ANorbury Frank R · Scottsdale, AZN9731TKarren Robert E · Mountain Home, IDN9732AMoremen Joshua · Sagle, IDN9734AGreen Theodore G II · Burlington, WIN9738ADemio Douglas · Westbrook, CTN973CCTalley John T · Clifton, TXN973KGRichard Mervin J Jr · Washington, DC
Back to AD 94-05-05 R1