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.
N8693YPeregrine Aviation LLC · Winfield, ILN86948Guglietta Jon R · Harwinton, CTN8694DJunek John M · Leonardtown, MDN8694NCitadelle Holdings LLC · Palmetto Bay, FLN86950Dale Jane L · Willow, AKN86953Madden Russell · Graford, TXN86954Breaking Wind LLC · Alabaster, ALN86957Swan Creek Flying Club · Ayr, NDN86959Collum Aviation LLC · Milton, FLN8695PDurflinger Aviation LLC · Otterbein, INFirst renewal noticeN8695WBurr Walker · Redmond, UTN8695YPurkinje Ltd LLC · Wilmington, DEN86968Crafted Enterprises LLC · Montrose, CON86969Sperry Sails Inc · Marion, MAN8696VMoynahan Thomas F · Newnan, GAN86974Qualitair LLC Trustee · MichelstadtN86977Ajs Aviation Inc · Spring Hill, FLN8697EMaze Bryan · Tulare, CAN8697LFried Stephen · Kingston, MAN8697VFisher Kurt Adrian Trustee · San Luis Obispo, CAN86983Hanson Curtis J · Peyton, CON86985Thomas Lucas G · Beebe, ARN86986Nelson Michael R · Philip, SDN86989Webb Terry M · Montreal, MON8698CRichard Waldren LLC · Newberg, ORN8699Blake Rodney · Trophy Club, TXN8699DBohannon James A III · Waller, TXN8699PKroll Corey · Gilbert, SCN8699RQuinn Michael P · Matthews, NCN869ATCxk1 LLC · Wilmington, DEN869BCInter American University Of Puerto Rico · Bayamon, PRN869CPExecutive Flight Institute LLC · Murrieta, CAN869EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN869FGMustang Sally Aviation LLC · Camden, SCN869GAtp Aircraft 9 LLC · Wilmington, DEN869KF3 Aero LLC · New Lenox, ILFirst renewal noticeN869NEJohn Cox LLC · De Witt, NEN869RRCooper Billy P · Columbia, MSN869RVThwaits John Drew · Ashland, MAN869TASheeptick LLC · Conrad, MTN869TTDimond Joan M · Birch Run, MIN869VLVieques Air Link Inc · Vieques, PRN869WCSchofield Wayne D · Polson, MTN86ABAir Sailing Inc · Reno, NVN86AJMullins Mark C · Riverside, CAN86AKBuss Bryce D · Homer, AKN86AT86at LLC · Elizabethtown, PAN86AVPlane Fun Inc Tr Trustee · Snellville, GAN86AYN86ay LLC · Burke, VAN86BEEmery Odus D Jr · Weslaco, TX
Back to AD 81-18-04 R2