AD 87-20-03 R2
Registered aircraft · 54,015
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-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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.
N92866Green Edward L · Chico, TXN9286ASimon Theodore E · Richmond, MIN9286BHall Leslie E · Lubbock, TXN9286CQueen City Flying LLC · Helena, MTN9286RWiebe Aerial Applications LLC · Peabody, KSN9286XRogne Fred A · Fallon, NVN92873Sonday Terrance P · Spring, TXN92878Jackson Richard L · Indianapolis, INN9287GCook Lynn H · Highland, UTN92881Patton Aviation LLC · Billings, MTN92886Lewis John E · Clayton, NJN92887Butler Aircraft Company · Walla Walla, WAN92888Knudsen Wayne D · Dakota City, NEN92889Miller Andy · Marana, AZN9288CChase Michael D · Albuquerque, NMN9288GPupkar Stephen B · Brookeville, MDN9288RShane Wilson Pa · Fort Myers, FLN92894Smith Rex H · Fort Bragg, CAN92895Dana Eric B · Davidson, NCN9289BWoodstock Aircraft Services Inc · White Lake, NYN9289GBolands North Inc · Binghamton, NYN9289XFull Send Aviation LLC · Fairview, TNN928ASA2g International LLC · San Juan Capo, CAN928HPeterson Michael A · White Salmon, WAN928JCLatimer Nelson R · Oxnard, CAN92908C-140 Company LLC · Pensacola, FLN9290BFitts Roger W · Independence, ORN9290GPhillips Richard L · Vienna, OHN9290XPetrich John W · Metaline Falls, WAN9291Henderson Charles B · Houston, TXN92912Hill Charles W · Russellville, ARN9291AEvans James · Tuolumne, CAN9291BVan Meerveld Dwight E · Poplar Grove, ILN9291CMadland Patrick S · Anchorage, AKN9291HDawson William F Jr · Port Hueneme, CAN9291RBobo Richard H · Okolona, MSN92922Perron Matthew B · West St Paul, MNN9292GDarter Lloyd R · Mountain Grove, MON9292HBlackhawk Flying Club Inc · Rockford, ILN92934Service Oriented Aviation Readiness (Soar) · Bolivar, MON92938Haney Christopher · Murrieta, CAN9293CHayes Dennis Paul · Des Moines, IAN9293XRod Ricky L · El Cajon, CAN92945Fla Inc · Wilmington, DEN9294BHall Justin E · York, NEN9294CBoulder Valley Aviation Inc · Boulder, CON9294HWet Dreams LLC · Erwinna, PAN9295BTow Dogs LLC · Kingman, AZN9295CLesmeister Dean J · Kindred, NDN9295HMiami Seaplane Tours Inc · Miami, FL
Back to AD 87-20-03 R2