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.
N616PCPork Chop Aviation II LLC · Hilliard, OHN616RHangar 21 Aviation Inc · Orange, CAN616RSHubert Richard A · Fowlerville, MIN616SFAmelia Reid Aviation LLC · San Jose, CAN616SKSuperior Flying Services LLC · Superior, WIN616SRBarendregt Melvin E · Heyburn, IDN616TBChristofferson Kevin J · Fruita, CON616TKScano James · Gunter, TXN616VTNamendorf Michael · New Hyde Park, NYN616WDHalama Patrick J · Whitehall, WIN61700Torres Ramon L · Mulberry, FLN61701Jls Aviation LLC DBA · Fredericksburg, VAN61703Beising Steven · Las Vegas, NVN61704Glick Mervin L · Stanardsville, VAN61707Spartan National Holdings LLC · Missoula, MTN61709Caldwell Clifton · Sterling City, TXN6170JSeeler John A · Bristol, NHN6170LCampbell Phillip · Fort Worth, TXN6170MRothe Zachary W · Riverside, CAN6170PMaurer Bruce C · Power, MTN6170SNice Flight LLC · Medford, ORN61710Bob Hoover Academy Inc · Salinas, CAN61713Miller Melanie L · Spanaway, WAN61718Ortman Bernard R · Bozeman, MTN6171LGoode Stephen C · Canton, TXN61727Mays Gloria J · College Station, TXN6172DBlue Spruce Aviation LLC · Fairview Park, OHN6172LKantor Dimitry · Essex, MDN61733Pan Air Flying Club Inc · Miami, FLN61737Executive Flight Institute LLC · Murrieta, CAN61738Finn Development LLC · Kaysville, UTN61739Southern Aero LLC · Homestead, FLN6173DArs Logistics LLC · Hackettstown, NJN6173PSwenson James A · Lake Point, UTN6173WDiaz Jose O · Ramey, PRN61743Carruth John T · Danvers, MNN61748Zapata Raymond E · Cabo Rojo, PRN6174DOtoole Makena · Cordova, AKN6174LHanson Alan L · Manchester, MIN6174PAbernathy Larry D · Vernon, TXN6174RLaurel Highlands Aeronautical Academy · Latrobe, PAN61752Lee Robert Eric · Charleston, WVN61755K E F Enterprises · Plymouth, MAN61759Watkins Joe C · Albany, GAN6175GKimber 123 Holdings LLC · Morgantown, WVN6175HLafferty Dietrich Ian · Brooklyn, NYN6175QKingsky Flight Academy LLC · Lakeland, FLN6175TNewell John D · Cleveland, TXN6175ZSpot-Air LLC · Burlington, TXN61760Little Duane V · Puyallup, WA
Back to AD 81-18-04 R2