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.
N9600LDavis Jim F · Poteau, OKN9600MAstrup Aviation Enterprises LLC · Lincoln, CAN9600SHargrove Tom R · Coffeyville, KSN9600UUniversity Of Oklahoma · Norman, OKN9601DRiffle David T · Woodinville, WAN9601JGevers Robert L · Lafayette, INN9601QSteel Aviation Inc · Walnut Cove, NCN9602BLaguna Verde Leasing Inc · Wilmington, DEN9602MCullen William P · Alexandria, VAN9602SKrepfl Martin J · Colorado Springs, CON96033Sullivan Leo W · O Fallon, ILN9603DHeartland Aviation Inc · Alliance, NEN9603FWylie Aviation LLC · Boise, IDN9603QConnecticut Flyers Inc · Madison, CTN9603UAviation Business Corp · Saint Louis, MON9603WMoore Alan Ray · Glenwood, ARN96042Aeropaint LLC · Wylie, TXN9604LBlue Grumman Plane LLC · New York, NYN9604QStevens Joel N · Monticello, ARN9604SFmco Promotions Inc · North Little Rock, ARN96052Copp James E · Adin, CAN9605CA O G Aircraft Services LLC · Aberdeen, NJN9605DDirty Side Down LLC · Downers Grove, ILN9605LStroberger Anthony S · Chandler, AZN9605MAsv Aviation LLC · Salem, ORN9605QBragan Ryan J · Dunedin, FLN9605RStieglitz Jeffrey B · Firth, IDN9605UCook Jacob D · Enid, OKN9605VBrookhart Brent Robert · Anaconda, MTN9605ZBorror Kevin Bruce · Grants Pass, ORN96060Silver Creek Ranch Inc · Austin, NVN9606DNiemi Danny L · Osage, MNN9606SMix Timothy R · Hubbard, ORN9606WMandolesi Daniel Martin · Hulmeville, PAN9607CLmc Aviation LLC · Goleta, CAN9607DRomo Mark A · Dillingham, AKN9607HTwin Oaks Airpark Inc · Hillsboro, ORFirst renewal noticeN9607RJohnston Bradley G · Ossining, NYN9607TPeterson Bradley E · Williston, NDN9607WK-9 Handler LLC · Henderson, NVN96088Griffith Kruz S · Bakersfield, CAN9608FDraper Floyd L · El Paso, TXN9608HCag Aircraft Holdings LLC · Crystal River, FLN9608JGomm Bruce J · Colfax, NDN9608KPiper Arrow N9608k LLC · Ann Arbor, MIN9608MWaryas Robert A · Long Island, VAFirst renewal noticeN9608QLahmers Melvin E · Newcomerstown, OHN9608RB2 West Corporation · Winona, MNN9608UNorth Shore Aviation LLC · Honolulu, HIN9608WBright Skies Sales & Leasing LLC · Hendersonville, TN
Back to AD 81-18-04 R2