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.
N9143JN9143j LLC · Fort Wayne, INN9143SBooton Charles E · Navarre, FLN9143VCrazy Mountain Cub LLC · Helena, MTN9143WLara Anthony Michael Thomas · Manitou Springs, CON9144TShiflett Philip B · Marietta, OHN9144VHardin Ralph · New Plymouth, IDN9144WMedema Roger E · Lake Forest, ILN9145CReitz Andrew P · Pembroke Pines, FLN9145JBonertz Brian J · Muscatine, IAN9145VRoe Cameron · Salt Lake City, UTN9146DSmith Paul G · Wasilla, AKN9146JSwarey Steven · Whiteville, TNN9146KBartlett Jesse Charles · Henderson, NVN9146LMalone Aaron E · Wasilla, AKN9146VWood David Allen · Conyers, GAN9146WGam Aviation LLC · Sioux Falls, SDN9147THoiles Richard C · Shortsville, NYN9147VN206ht LLC · Pulaski, IAN9147WBishop Samuel E · Soquel, CAN9148GCheutin Didier V · Orlando, FLN9148JNovember Nine One Four Eight Juliet LLC · Fulton, MON9148SBlue Skies Aviation LLC · Holland, MIN9148XFaik Salaheddine · Marion, IAN9149CBryan Robert G · New Lenox, ILN9149JJones Lynn · Birmingham, ALN9149QCovington James A · Huntsville, ALN9149SBurnard Russell J · Seward, AKN9149WTcherneshoff Robert · Clayton, NMN914ADDepinet Andrew P · Galion, OHN914AMWilliamson Tom P · Nacogdoches, TXN914AZN969az LLC · Miami, FLN914DSaker Air LLC · Charlotte, NCN914DPGonzalez Ramiro · Lancaster, OHN914ETrettin Anthony K · Mason City, IAN914GPRoy Dino · Saginaw, TXN914HMeadows Mark A · Mooresville, INN914HMMiesler Hans U · Penrose, CON914HPBonsey James E · Newberg, ORN914JBSwartz Eric C Trustee · Aptos, CAN914JDAis Wings LLC · Grand Rapids, MIN914JWWright John T · Jacksonville, FLN914MGHolman Larry E · Cleveland, GAN914PLand-O-Lakes Flying Club Inc · Bloomfield Hills, MIN914PACoco Aircraft Inc · Merritt Island, FLN914RLNichols Charles C · Hanford, CAN914RRMartinez Jeff L · Lewistown, MTN914SCole Thomas Ed · White Settlement, TXN914SCHotel Aviation LLC · Oregon City, ORN914SWSilver Express Co DBA · Miami, FLN914THanley Stuart · Hollywood, FL
Back to AD 81-18-04 R2