AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N6924PLauderback Lee L · Fort Collins, CON6924QPag Air LLC · Concord Township, OHN6924USchleisman Terry J · St George, UTN6924VBramer Aviation LLC · Middleburg, PAN6924WAlpha 3 LLC · Troy, KSN6925NFollrath Rick C · Ludington, MIN6925UDurocher Michael G · New Hudson, MIN6925VMay Michael S · Axtell, NEN6926DGibson Christopher R · Natchez, MSN6926HJust Plane Adventures Inc · Crystal Lake, ILFirst renewal noticeN6926KRed Wolf Aviation LLC · Venice, FLN6926NTurtle Mountain Air LLC · Bottineau, NDN6926PSkyways Group LLC · Greensboro, NCN6926UCreed Stephen R · Fort Worth, TXN6926WCola Air LLC · Irmo, SCN6927JClear2fly Aerospace LLC · Daytona Beach, FLN6927KLord Mary E · Kalama, WAN6927NFlying High LLC · Gore, VAN6927QIowa Military Aviation Heritage Museum · Ankeny, IAN6927UJones Robert Y · Alba, TXN6928DRegistration Pending · West Yellowstone, MTRegistration pendingN6928HMaya Air Services LLC · Lee, NHN6928NToysformud LLC · Missoula, MTN6928POwen Colin Jc · College Station, TXN6928VSky West Aviation Inc Trustee · Albuquerque, NMN6928WHammons Daniel G · Vadnais Heights, MNN69290Kflyin LLC · Colorado Springs, CON6929DJohnson Timothy D · Chapel Hill, NCN6929JMhz5620 LLC · Fitchburg, WIN6929UEisenhardt Scott · Milwaukee, WIN6929VHerzog Property Management LLC · Fergus Falls, MNN692ACMarshall Carol A · Lees Summit, MON692ASJgm Aviation LLC · Spring, TXN692CFG&M Aircraft Inc · Wheat Ridge, CON692CPCivil Air Patrol · Maxwell Afb, ALN692HMReagan Jason E · Sevierville, TNN692LHChristiansen Aviation LLC · Wilmington, DEN692MADevine James W · Columbus, OHN692SEmley Steven Allen · Port Angeles, WAN692SKWings Over Texas Holdings LLC · Denton, TXN692SPSmith Holdings Inc · Wilmington, DEN6930JSkypark Aero Club Inc · Troy, OHN6930VMatisko Michael J · Newburgh, INN6930WFlat Out Aviation LLC · Mercer, MON6931DThomas Isaac F · Portland, ORN6931JMissouri Valley Flying Club Inc · Culbertson, MTN6931KValiair Limited Co Trustee · Casper, WYN6931UMascagni Jerry Scott · Greenville, MSN6932BHauser Nathan · Newark, DEN6932FBruns Luke J · Flower Mound, TX
Back to AD 81-18-04 R2