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.
N80952Registered aircraftN80959Mets Flying Club Inc · Fairmount, INN8095ADay Gordon Jr · Fort Atkinson, WIN8095GTrulock Todd N · Ontario, CAN8095HSimmer Aviation LLC · Missoula, MTN8095PGramas Illya W · Shelby, MIN8095WSkierka Michael A · Browning, MTN8095YN8095y Inc · Oakdale, MNN80960Perry Robert Lawrence Trustee · Salinas, CAN80961A S Air LLC · Lantana, FLN80964Three Wing Flight School LLC · Stratford, CTN80968Wisconsin Aviation Inc · Watertown, WIN8096JBullgoose Aviation Inc · York, PANon-citizen corporation, flight hours not reportedN8096LRhinebeck Aerodrome Museum · Rhinebeck, NYN8096PTsacoyianis Jonathan J · Pascoag, RIN8096QHoover Charles J · Logansport, INN8096SFreedom Aircraft Jv 1 LLC · Milton, FLN8096VPlatt Philip L · Concho, AZN8096WRoberts Heather V · Birmingham, ALN80972Porter Timothy D · Saint Cloud, MNN80975N80975 LLC · Wilmington, DEN8097CImmell Michael · Buffalo, OKN8097HMiloud Chadd K · Fort Worth, TXN8097JAjdari Rodmehr · Millville, NJN8097PEmery Jonathan D · Payson, AZN8097QHissey Mark E · Fannettsburg, PAN8097SBrookwood Plastering Inc · San Diego, CAN80982Reiselt Paul T F · Corinth, MSN80985Mullins James C · Franklin, TNN8098BIowa Aircraft Inc · Burlington, IAN8098ERegistered aircraftN-number assigned, not yet registeredN8098MRock Solid Aviation LLC · Lake Charles, LAN8098NBlessing Gary · Cape Coral, FLN8098PTaylor Edith E · Como, NCN8098YPestair LLC · Wilmington, NCN80991Flowers Robert Clyde III · Manchaca, TXN80996Halley Dan R · Avery, TXN8099NArthur Kezian Inc · Los Angeles, CAN8099QKocher Gary E · Bellingham, WAN8099VGrannetino Gerald F · West Chester, PAN8099WClarion County Flight Club LLC · Shippenville, PAN8099YMs Aero Inc · Lakeville, OHN809APPhillips William Wade · Lake Charles, LAN809BTLouisville Aircraft Leasing LLC · Louisville, KYN809BWGilly Christian · Newtown, PAN809CPCivil Air Patrol · Maxwell Afb, ALN809DWReed Land & Properties LLC · Kalispell, MTN809EMDepartment Of Homeland Security · Washington, DCN809GTDepartment Of Homeland Security · Washington, DCN809HWDepartment Of Homeland Security · Washington, DC
Back to AD 87-10-06 R1