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.
N80772Payne Michael S · Sequim, WAN80773Boyl Traci L · Ukiah, CAN80774Dugger Aviation LLC · Merritt Island, FLN80775Sierra Bravo LLC · Littleton, CON80779Stein William R · Aptos, CAN8077ESws Aviation Services Inc · Titusville, FLN8077H8077h LLC · Southington, CTN8077NRodgers Wesley T · Enterprise, ALN8077QWakefield Robert · Toccoa, GAN8077RIscovich Mario S · Thousand Oaks, CAN8077WN8077w Inc · Bloomfield Hills, MIN8077YMagenta Line LLC · Geneva, NYN8078Tkg Aviation LLC · Denver, CON80781P D H S Aerial Photography Inc · Spicewood, TXN80784Stamm David A · Lake Almanor, CAN80785Campbell Air LLC · Angola, INN80788Bell Aa Flying Club Inc · Mechanicsburg, PAN8078DStevenson William E · Sutton, AKN8078PComanche Partners · Manhattan, MTFirst renewal noticeN8078RKhozam George · Murrieta, CAN8078ZL & A Bennett Second Family Lp · Renton, WAN80790Wingsleasing LLC · Wichita, KSN80797Neitz Frank · Bethel, AKN80798Thomas Dean Properties LLC · O Fallon, MON8079JTd Aviation LLC · Canton, GAN8079WFox Michael · Winfield, KSN8079YKaszuba Peter M · Bradenton, FLN807ABSunward Aviation Services LLC · Merritt Island, FLN807APTexas South Wind Aviation LLC · Kenedy, TXN807DAMays Gloriaj · College Station, TXN807DBAnderson Richard D · Trophy Club, TXN807EHLindsey Daniel Rey · Clovis, NMN807EJBaldmans Aircraft Services LLC · Wilmington, DEN807FPM&A Industrial Construction LLC · Atkinson, NEN807HDTubbs Jerry M · Manns Harbor, NCN807LELeading Edge Flight Academy LLC · Bend, ORN807NVUnited Helicopter Leasing LLC · Honolulu, HIN807RVMayerhofer Andrew M · Sugar Grove, ILN807SPCawthon James B · Chelsea, ALN807TATigersair LLC · Amityville, NYN807TFAir Fleet Holdings LLC · Addison, TXN807TMLidija LLC · Grass Valley, CAN807WMGriswold George B III · Cedar Point, NCN807WTWindigo Transportation Inc · Waterloo, IAN80800West Bend Air Inc · West Bend, WIN80803Bradley Charles S · East Bethel, MNN80807Wings Over Texas Holdings LLC · Denton, TXN8080AChapel Hill Flying Club Inc DBA · Sanford, NCN8080UMaas Justin J · Columbus, INN8080YEmerald City Aircraft Leasing Inc · Port Orchard, WA
Back to AD 87-10-06 R1