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.
N2002NPlane Fun Inc Tr Trustee · Snellville, GAN2003CEggert Thomas F · Woodbury, MNN2003KTobin Garvee Irene · Anchorage, AKN2003LOllmann Paul W · Poplar Grove, ILN2003XYelton Darrell A · Pleasant Hill, MON2003ZBehnken Paul · Sedgwick, MEN2004ASwistunowicz Zygmunt S · Newtown Square, PAN2004ERazore Mark J · Ferndale, WAN2004KCalhoun Jerry H · Washington, NCN2004NKershaw Gloria D · East Tawas, MIN2004ZWhiting Robert A Jr · Scarborough, MEN2005HLaslo Lawson P · Oklahoma City, OKN2005NMoore Michael T · Liberty Lake, WAN2006NBreeding Jarrard L · Sharpsburg, GAN2006ZN2006z LLC · South Hill, VAN2007BVan Linder Richard A · Scotts, MIN2007YFoster Lemuel E · Vancouver, WAN2007ZRau John M · Liberty, KSN2008VRossiter David A · Sioux Falls, SDN200ALMekolik Aaron S · College Station, TXN200KTKeeton Andrew · Palestine, TXN200LMHorowitz Scott J · Kamas, UTN200PYPeterson Seth N · Gulfport, MSN200QKNeidenthal Michael P · Henderson, NVN200RXAndrews Laral B · Portland, ORN200SDKing Dwayne W · Sutton, AKN200XQShannon Air Museum LLC · Fredericksburg, VAN2010NMccoy Michael David · Mentor, OHN20110Tridle Keith D · Burlington, WIN2011BBrandon Thomas C · Prospect, PAN2011KChidester Leo S · Tremonton, UTN2011NSutton Jesse K · Hutchinson, KSN2012VClare Ross W · Sodus, MIN2013BHiggins David R · Ellensburg, WAN2013YRoberts Michael R · Plano, TXN2014VQuinn Timothy L · Tujunga, CAN2015YHoing Randal H Jr · Mexia, TXN2016VJenkins Robert W · Fredericktown, OHN2016ZPederson William K Jr · Hillsboro, ORN2017BStieber Harold J · Brownwood, TXN2017KMorris Shane E · Pewaukee, WIN20188Creamer Rodger R · Venice, CAN2018NNixon David W · Portland, ORN2018ZBurkel Shawn W · Greenbush, MNN2019YThuet Robert C · Spartanburg, SCN201AAAdventures In The Sky Aviation LLC · Fresno, CAN201KWalker Patrick R · Germantown, MDN2020JAusten Air Racing Inc · Wilmington, DEN2020MBusque Michael J · Palmyra, MEN2020NHair Cory A · Collinsville, OK
Back to AD 94-05-05 R1