AD 94-05-05 R1
Registered aircraft · 26,232
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.
N76189Westrum Durl Troy · Norwalk, IAN76190Thomson Bruce M · Albuquerque, NMN76196Johnson Harry L · Live Oak, CAN7619XWeitzel Claus P · Newington, GAN761MAWilliams Charlie · Trenton, SCN762Thomas Vet E · Hilton, NYN76203Durand Gregory M · Marquette, MIN76206Registered aircraftN76208Robinson Michael F · Granbury, TXN76209Beard Garrett T · Pelahatchie, MSN7620BStancil James T · Jasper, GAFirst renewal noticeN7620XRegistered aircraftN76212Marburg Loren C · Indianapolis, INN76213Lucy Donald E · Newbury Park, CAN76218Hall Charles M · Lubbock, TXN76219Haas Michael S · Richmond, VAN7621MTorres Richard M · Valley Springs, CAN7621TScheetz Wayne E · Center Point, IAN7622TFuhrman Chad L · Manchester, TNN7622XReale R Robert · Marblemount, WAN76232Mischock Andrew J · Waukesha, WIN76234Sprockett Jill L · Punta Gorda, FLN76239Robinson William A · Franklin, TNN7623XDorman David L · Garfield, MNN7624Derwin Lawrence R · Santa Paula, CAN76240Stick And Rudder Aero LLC · Millwood, WAN76244Elliott Russell P · Greencastle, INN7624TAir & Opportunity Aviation LLC · Yorktown, VAN76253Colwell Jeffrey J · Tipp City, OHFirst renewal noticeN76256Groeneveld John · Maryland Heights, MON76257Weston Jeff A · Port Saint Lucie, FLN76258Lee Li · West Covina, CAN76267Reece Andy · Marysville, WAN7626TKoch Suzanne Elizabeth · Battle Ground, WAN76275King Adam J · Kalamazoo, MIN76277Hauser Linda L · Ulysses, KSN76278Yeazel Matthew A · Seattle, WAN7627XFindley Michael A · Moreland, GAN76282Helquist Carl A · Fort Wainwright, AKN76284Boss Christopher S · East Newport, MEN76286Baggot John P · Shiocton, WIN76289Barrett Michael S · Bigfork, MTN7628XZintz Michael S · Centerville, IAN76290Witt Autry A · Fort Worth, TXN76291Sheban George J · Dallas, TXN76292Goold Arthur M · Chesterfield, INN76293Koester David P · Newport, ORN76295Bassett Joseph T · Lovell, WYN7629TBork Joseph L · Masier, ORN7629XNeu Aviation LLC · Benton, LA
Back to AD 94-05-05 R1