AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N15376Brown William D Jr · Mount Pleasant, TXN15377Johnson Matthew · Biglerville, PAN15378Ketcham Jesse E · Aguanga, CAN15379Huyler John C · Shreveport, LAN15380Miller Aviation Group LLC · Coon Rapids, MNN15383Nevill Donald L · Clare, MIN1538RAction Aerospace LLC · Bluffton, SCN1538XStaton Justin · Kemah, TXN15391Lyon Anthony R · Bethesda, MDN15392Dgm Aviation LLC · Hurricane, WVN15396Nomann Arnold H · Viroqua, WIN15397Boisvert Thomas Michael · Sonoita, AZN153AAHorn Jack E · Erie, CON153ACN153ac LLC · Eldon, MON153AMMedford Daniel E · Lakeville, MNN153BAGeorge Tim D · Cleburne, TXN153BDM & M Farms · Fowler, KSN153CHarless Richard K · Battle Mountain, NVN153EJQualitair LLC Trustee · MichelstadtN153GReese Paul D · Elkview, WVN153GHHealey David A · Hammondsport, NYN153GMFly High Aviation LLC · Melrose Park, ILN153JPPew John R · Casa Grande, AZN153JRRs Helicopters Inc · Lake Wales, FLN153LMSkylens LLC · Hammond, LAN153MBaker Thomas J · Oxford, MDN153MCHollingshead Keith · Clarksboro, NJN153MKThomas Paul · Falls Church, VAN153PCRegistered aircraftN153SHSpitzer Helicopter LLC · Woodland Hills, CAN153TAAmerican Eagle 1 LLC · Kimberling City, MON153WBOster Dale E · Trego, MTN153WFSouthern Aircraft Consultancy Inc Trustee · Casper, WYN154Nystrom Timothy L · Foreston, MNN15405Kurin Kerry · Tulsa, OKN1540RPolar Tigers Inc · North Oaks, MNN15410Simpson Randal L · Missouri City, TXN15417Coburn Kyler J · Mountain Home, IDN1541CSwan Russell · Glenside, PAN1541RHall Daniel · Haskell, OKN1541XSheffer Marshall A · Herrin, ILN15426Piper Pilots LLC · Wilsonville, ORN1542RHoose Michael J · Cortland, NYN15438Max Motors LLC · Encino, CAN1543RHettlinger Eric R · Terre Haute, INN15442Buchanan Ethan D · Au Gres, MIN1544CElite Approach LLC · Chesterfield, MON1545RSanders Harrison S · West Columbia, TXN15471Sport Air Inc · York, PAN15472Wild Wingdom LLC · Greenville, SC
Back to AD 2006-10-21