AD 87-10-06 R1
Registered aircraft · 72,010
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:87-10-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
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:87-10-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1') 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.
N9897QAbove All Aviation Inc · Santa Barbara, CAN9897YCline Braxton L · Wasilla, AKN98981Airplane And Drone Flight Instruction LLC · Orlando, FLN9898DBailey Ronald C · Anchorage, AKN9898QSecond Wind Aviation Corp · Friday Harbor, WAN9898UOlenick Christopher M · New Richmond, OHN9899GWings Over Texas LLC · Denton, TXN9899QBrown Richard K · East Falmouth, MAN9899UStott Rick T · Bynum, MTN989ASSkupin Charles G · Riverview, MIN989CWCardinal Wings Aviation LLC · Buckner, KYN989DAPrice Jeremy D · Wasilla, AKN989DWMitchell Benjamin R · Ogden, UTN989EHRegistered aircraftN989JBAltes 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, NEN989SRBas Part Sales LLC · Greeley, CON989TMPrestige Wordwide Km LLC · Lynn Haven, FLN989WUEglin Aero Club · Eglin Afb, FLN989XLCentral Global Contractor LLC DBA · Saline, MIN98ABooe Kent W · Clay City, INN98AMRichter Rick D · Anchorage, AKN98AWBrewer 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, NVN98EEMaples Jeffery · Wilmington, DEN98EMGreen Tool & Die Co LLC · Honesdale, PAN98ETDupuis Joseph A · Kingman, AZN98FSLittle Nova Foundation · Wilmington, DEN98GBBinse Gerald R · Yuba City, CAN98GCGarcia Alexandra · Pompano Beach, FLN98GGSandlapper Aviation Of De Inc · Bennington, VTN98GHWdbr Solutions LLC · Guthrie, OKN98GPHammack Philip Scott · Canton, MS
Back to AD 87-10-06 R1