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.
N989CPCivil Air Patrol · Maxwell Afb, ALN989CWCardinal Wings Aviation LLC · Buckner, KYN989DAPrice Jeremy D · Wasilla, AKN989DWMitchell Benjamin R · Ogden, UTN989EHRegistered aircraftN989FLPiper Aircraft Inc · Vero Beach, FLN989JBAltes Matthew C · Mount Shasta, CAN989JLCox John W · Corpus Christi, TXN989LBBenishek Lowell D · Canon City, CON989LEClark James L · West Des Moines, IAN989MAButler Holdings · Franklin, TNN989RAAvco Patrol LLC · Lyndon, KSN989RMMellon Marvin Richard · Naples, FLN989RVLivingston Charles J · Valley, NEN989TMPrestige Wordwide Km LLC · Lynn Haven, FLN989WBCp Aviation Inc · Santa Paula, CAN989WDTextron Aviation Employees Flying Club Inc · Wichita, KSN989WUEglin Aero Club · Eglin Afb, FLN989XLCentral Global Contractor LLC DBA · Saline, MIN98ABooe Kent W · Clay City, INN98AHBabka Russell J · North Barrington, ILN98AMRichter Rick D · Anchorage, AKN98APSpx Communications Inc · Capitola, CAN98AWBrewer Duncan J · Kenai, AKN98BEEckel Bonita L · Hernando, MSN98BPUrban Larry D · Conroe, TXN98BRGrant Brian · Durham, NCN98CDButler Thomas K · Austin, TXN98CJBekkevold Raymond Fredli · Cleveland, TNN98CTRote William E · San Marcos, CAN98CULeger Daniel R · Laporte, MNN98CXRubino Chad L · Great Falls, MTN98DBDb Aero Restoration LLC · Wilmington, OHN98DGGoins Donald L · Marion, OHN98DWFlying Wolf Aviation LLC · Okeechobee, FLN98DXInternational Air Services Inc Trustee · Carson City, NVN98DZZawitz Darryn N · Mars, PAN98EEMaples Jeffery · Wilmington, DEN98EMGreen Tool & Die Co LLC · Honesdale, PAN98ERAircraft Guaranty Corp Trustee · Oklahoma City, OKN98ETDupuis Joseph A · Kingman, AZN98FFPeregrine Howard Fund V Owner LLC · New Orleans, LAN98FSLittle Nova Foundation · Wilmington, DEN98FWHysell Donovan W · Atwater, OHN98GBBinse Gerald R · Yuba City, CAN98GCGarcia Alexandra · Pompano Beach, FLN98GGSandlapper Aviation Of De Inc · Bennington, VTN98GHWdbr Solutions LLC · Guthrie, OKN98GPHammack Philip Scott · Canton, MSN98GREl Coyote Ranch LLC · Alzada, MT
Back to AD 81-18-04 R2