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.
N6604PBrookhouser David L · Creighton, NEN6604UMr Dent Inc · Manheim, PAN6604WSedberry Jason A · Kokomo, INN66052Gerot David · Janesville, MNN6605DAlameda Aero Club · Alameda, CAN6605FPurdue Aviation LLC · West Lafayette, INN6605JPatton Janet · Denton, TXN6605RRegistered aircraftN6605UFoster Henry R · Saint George, SCN6605WChadwick Joseph G · Fayetteville, GAN6606DRegistration Pending · Sturgeon Bay, WIRegistration pendingN6606FWestfall William L · Sunbury, OHN6606JSale Reported · Warner Robins, GASale reported, canceledN6606WMobley Ray M Jr · Midlothian, TXN66070Obetz Robert S · Manheim, PAN6607PHaumesser Daniel T · Kenosha, WIN6607UN6607u LLC · Commerce City, CON66084Cummings Steven R Trustee · Wyarno, WYN6608DAmericus Flying Club Inc · Americus, GAN6608JGreat Lakes Aviation Services Inc · Kimball, MIN6608RBogovich Robert E · Clifton, TXN6608URb II LLC · Walker, MNN6608WGrant Hooks LLC · Middleburg, FLN66090Skyline Solutions Inc · Deland, FLN66091Ftg Leasing LLC · Watkins, CON66097Gaskin Greg · Lake Almanor, CAN6609EClark Andrew M · Bend, ORN6609LUsda Aphis Ws · Cedar City, UTN660AAFms Bank · Fort Morgan, CON660ACSmooth Air LLC · Richboro, PAN660BBKeys Vacation Rentals LLC · Palm City, FLN660DBAnderson Samuel D · Marana, AZN660FTFlorida Institute Of Technology Inc · Melbourne, FLN660HBJames Dennis A · Fort Valley, GAN660MMAircraft Guaranty Corp Trustee · Oklahoma City, OKN660PCObrien Kenneth J · Lafayette, CON660RWHay Johnny L · Bethel, OHN660SPRobert Devers Solutions · Hermosa Beach, CAN660SRAom Aircraft LLC · Orlando, FLN660TAReinhardt Anthony C · Duchesne, UTN660TMPeacock Quarry L · Post Falls, IDN6610Seyour Lori L · Woodstock, GAN66100Pj Aviation Holding LLC · Eden Prairie, MNN6610JSaracoff Norman L · Neillsville, WIN6610PBarr Merlin A · Clarinda, IAN6610UTreichler Peter DBA · East Aurora, NYN6610WHattersley Donald C · York, SCN66111Cutlass 661 LLC · Orange Park, FLN6611DMoralli Joseph · Chico, CAN6611PSelect Charities LLC · Spokane, WA
Back to AD 87-10-06 R1