Registered aircraft · 29

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

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:96-16-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-16-06') ORDER BY n_number

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:96-16-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-16-06')
  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:96-16-06')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-16-06')
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.

N197SKBeery Milo A · Clarinda, IAS/N 1645 N1999RRas Inc · Danbury, NEBuilt 1997 · S/N 1649 N20003Hopkins Robert E Jr · Sumter, SCBuilt 1992 · S/N 1552 N2002EBeery Milo A · Clarinda, IABuilt 1992 · S/N 1554 N2009WMorris Shepherd · Shorter, ALBuilt 1993 · S/N 1560 N20122Gust David R · Harwood, NDBuilt 1994 · S/N 1564 N2015NHigh Performance Aviation LLC · Davidson, NCBuilt 1993 · S/N 1567 N2021SJersey Devil Dusters LLC · Southampton, NJBuilt 1993 · S/N 1571 N20263Ras Inc · Danbury, NEBuilt 1994 · S/N 1575 N2032JArnt Aerial Spraying Inc · Worthington, MNBuilt 1994 · S/N 1583 N2034MSchindler Rick M · Neligh, NEBuilt 1995 · S/N 1588 N2035NPlus Flying Service Inc · Ekalaka, MTBuilt 1995 · S/N 1591 N4627GDunn Blake C · Bristol, COBuilt 1991 · S/N 1532 N4628URons Air Service Inc · Two Buttes, COS/N 1530 N4640DRons Air Service Inc · Two Buttes, COS/N 1531 N46455Page Aerial Service Inc · Rochelle, ILBuilt 1991 · S/N 1535 N4647EFoss And Meier Flight Service · Devils Lake, NDS/N 1537 N4656MHofer Perry L · Doland, SDBuilt 1992 · S/N 1540 N620RSAeschliman Arlie W · Tribune, KSBuilt 1996 · S/N 1617 N620SACropair Flying Service Inc · Cody, WYBuilt 1997 · S/N 1646 N65876Kidd Clifford L III · Monahans, TXS/N 1654 N9000PCochrane Aaron W · Lake Bronson, MNBuilt 1995 · S/N 1600 N90181Air Dakota Flite · Hettinger, NDBuilt 1996 · S/N 1613 N90182Tolen Dave · Gallatin, MOS/N 1614 N90225Moores Aerial Applicators LLC · Morehead City, NCBuilt 1996 · S/N 1622 N90275Double M Farms LLC · Walsh, COBuilt 1996 · S/N 1637 N90393Skyline Aviation LLC · Lewistown, MTBuilt 1995 · S/N 1594 N9057GCb Aerial Application LLC · Queen City, MOBuilt 1997 · S/N 1647 N9057TRegistration Pending · Queen City, MORegistration pendingBuilt 1997 · S/N 1648

Back to AD 96-16-06