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.
N4709EMiller Aircraft Services Inc · Crookston, MNN4709HLinse Kelly L · Plattsmouth, NEN470EHKirkwood Aeronautics LLC · Bicknell, INN470HDChandler Dennis · Castroville, TXN470JBLong James · Lyman, WYN4710MHerrick D E · Plymouth, MIRegistration revokedN4711CN4711c Inc · Stillwater, MNN4711TDelaney Spencer R · Fairfield, CAN4711XKirby John D · San Diego, CAN47123Pittsburgh Aviation Enterprises Inc · Ellwood City, PAN4712EWaggoner David F · Aurora, ORN4712TKilcourse Jeffrey Kenneth · Tequesta, FLN4712XBludorn Matthew R · Bryan, TXN4713HPreszler Joel R · Braddock, NDN4713TMichigan Air Service Corp · Troy, MIN47140Sproule Peter J · Buckley, WAN4714ECampbell Brett L · Kirksville, MON4714TJed Homes Inc · Lisbon, CTN4714XHoffman Zachariah M T · Glendale, AZN4715EWings Of The North Inc · Eden Prairie, MNN4715MHandly W A · Arcola, MSN4715XBlair Ross Iain · Milford, NJN4716HRipplinger Paul P · Enderlin, NDN4717EMalsberger Tim J · Blakely, GAN4717TStartin Tyler D · Colfax, WAN4718TArcand David R · Forest Lake, MNN4718XRobb James W · Uhrichsville, OHN4719EMcmillan Rickey F · Mission Hills, CARegistration revokedN471JLindenschmidt Robert J · Evansville, INN471PBSpeer James M Jr · Boonville, NCN4720HWiplinger Charles · Inver Grove, MNN4720MHutton Mark B · Denison, TXN47212Brooks Ronald L · Loveland, OHN4721EQuast George Walter · Hutchinson, MNN4721GRutkiewicz Adolph H · Ravena, NYN4723EAddington James T · Denton, TXN4724CHarvey Douglas W · Shreveport, LAN4724EFarringer Steven R · Columbia City, INN4724MHoudek Dennis E · Roseburg, ORN4725EAgaliotis Paul E · San Martin, CAN4725HIsland Air LLC · Eagan, MNN4726XDoebler H Andrew · Myrtle Beach, SCN4727EKw Group LLC · Philipsburg, MTN4727MLeland Edwin S · Yuba City, CAN4727TRimediare Aircraft LLC · Tucson, AZN4727XN4727x LLC · Palmdale, CAN4728EJohnson Gregory T · Stanley, NDN4728HJensen Brian P · Eagan, MNN4729MTonys Aerial Spraying Inc · Great Bend, KSN4729TNevergall Michael · Brighton, CO
Back to AD 94-05-05 R1