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.
N6517DSlaboszewski Donald W Jr · Joliet, ILN6517JSwaz Aviation LLC · Mesa, AZN6517LBrown Hunter J · Starkville, MSN6517PJames Dennis · Pleasant Grove, CAN6517UNova Accounting LLC · Herndon, VAN65180Mccraw Bryan · Telephone, TXN6518LBergen Maxwell · Charlotte, NCN6518PRubscha Rick L · Peoria, AZN6518UWhetzel Peter W · Mathias, WVN6518WWedmore Catherine A · Wellington, FLN6518ZSimmons Aviation Services LLC · Pawcatuck, CTN65191Bampton Dennis · Portage Des Sioux, MON65192Tactical Integrated Training Solutions LLC · Colorado Springs, CON65194Vliegen LLC · Urbandale, IAN65195Sciortino Warren A III · Crested Butte, CON65197Aviator Education LLC · Greeley, CON65199Long Island Aviators LLC · Seaford, NYN6519JDms Defense LLC · Annapolis, MDN6519LRegistration Pending · Saint David, AZRegistration pendingN6519RC & C Aeroventures LLC · Carson City, NVN6519TVeverka Merle G · Frederick, CON6519USherr Steven · Mandan, NDN6519WFalcon Aircraft Services Inc · Rockford, ILN651ABlauser Edward C · Mansfield, OHN651DMAircraft Guaranty Corp Trustee · Oklahoma City, OKN651ECEagle Sky Patrol Inc · Deadwood, SDN651EDFlying Colors Airpants Inc · Leesburg, FLN651EREmbry-Riddle Aernautical University Inc · Prescott, AZN651FLGillam Charlene · Akron, OHN651FTSt Louis Flight Training LLC · Cahokia, ILN651KCPacific Flight Aviation LLC · Costa Mesa, CAN651LMMeinhardt J Karl · North Fort Myers, FLN651MPortmann Seth R · Noblesville, INN651MAPea-Wayman Flight LLC · Daytona Beach, FLN651PASmn Investments Inc · Greeneville, TNN651RBBrown Russell D · Lebanon, TNN651RKChristensen Nathan · Newnan, GAN651RVKiloh James W · Cypress, TXN651TPGray Dylan · Alliance, OHN651TSGoodfellow David · Sutherland, VAN6520CVail Communications Inc · Orangevale, CAN6520LShiner Gary P · Wichita, KSN6520PMoffett Jules M DBA · Elmore, ALN6520ULundquist Justin Carl · Sarasota, FLN6520WP T Arts LLC · Grand Rapids, MIN6520ZWolter Randall R · Frederick, SDN652171434 Jpl LLC · Wilmington, DEN6521DWaade Odd · Bellingham, WAN6521LRegistered aircraftN6521QAlpha Wings Inc · Willoughby, OH
Back to AD 81-18-04 R2