Registered aircraft · 2,130

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:2009-13-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:2009-13-06-R1') 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:2009-13-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:2009-13-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:2009-13-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:2009-13-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.

N705SFLet Industries LLC · Lewes, DEBuilt 1974 · S/N 27-7405311 N706JRDodson International Parts Inc · Rantoul, KSS/N 42-5501050 N706SPEastern Cincinnati Aviation Inc · Batavia, OHBuilt 1974 · S/N 27-7405394 N707HHT And L Restaurant Groups Aviation LLC · Hattiesburg, MSS/N 31-8112067 N70846Dc Aero LLC · Ramona, CABuilt 1971 · S/N 274593 N708SAOlivier Seth Nicholas · Baskin, LABuilt 1981 · S/N 31T-8104042 N7091YJudie Bear Air LLC · Bend, ORS/N 23-4 N709HSRokaboka Ltd · Mount Ida, ARFirst renewal noticeS/N 27-3615 N709SAN709sa LLC · Maxville, FLBuilt 1983 · S/N 318352027 N70FLFl Jet Services Inc · Miami Springs, FLFirst renewal noticeBuilt 1978 · S/N 31-7952030 N70GWAncient City Capital LLC · Saint Augustine, FLBuilt 1980 · S/N 31T-8104004 N70HHAmys Aircraft Services LLC · Bridgeton, MOBuilt 1974 · S/N 31-7405208 N70PBFreeman David B · Liberty, NCS/N 273146 N70TLAltitude Adjusters LLC · Cranford, NJBuilt 1965 · S/N 27-2797 N70TWGunter Lennon DBA · Tabernacle, NJS/N 31T-7904043 N710DGNavajo Holdings LLC · Naples, FLS/N 31-7305017 N710JJLachatel Sisters Boutique Inc · Miami, FLBuilt 1976 · S/N 31P-7730002 N710JPSt Matthew Aviation Company LLC · Kalispell, MTBuilt 1979 · S/N 31-7952086 N711ERCommunications Laboratories Inc · Melbourne, FLBuilt 1981 · S/N 31T-8104056 N711KHDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 27-7954036 N711MAKiddie Hawk Air Academy · Littleton, COS/N 31-7652159 N712JTSkylens LLC · Hammond, LABuilt 1979 · S/N 27-7954057 N712TMHudson Valley Helicopter Flight Services LLC · Salt Point, NYBuilt 1979 · S/N 27-7954083 N7139BNortheast Travel Corp · Brooklyn, NYBuilt 1980 · S/N 42-8001042 N713ECCharlie Tango LLC · Mechanicsville, VABuilt 1975 · S/N 27-7554151 N713VSJrr Professional Services LLC · Davie, FLBuilt 1974 · S/N 277405415 N713WTWtw Air LLC · Houston, TXBuilt 1977 · S/N 31-7752138 N71481Jib Inc · Groton, CTS/N 31-8352029 N715AJA&J Air Sales Inc · San Antonio, TXS/N 31-7405405 N7164DAir Arctic Inc · Fairbanks, AKBuilt 1980 · S/N 31-8052013 N717UOcean Abaco LLC · Virginia Beach, VABuilt 1983 · S/N 31-8352026 N717WSCutting Edge Sales LLC · Santa Fe, NMBuilt 1961 · S/N 27-415 N7181YEagle Aeronautics LLC · Chicago, ILS/N 27-8054021 N718MWescon Margin Inc · Wilmington, DEBuilt 1979 · S/N 27-8054011 N71FLWest Transportation LLC · West Bloomfield, MIBuilt 1968 · S/N 27-3969 N71LKChallenge Tool & Mfg Inc · New Haven, INS/N 31-8052155 N721CEErtel Thomas H · Charlotte, NCBuilt 1980 · S/N 31-8112002 N7222FGriffin Aviation LLC · Great Falls, VABuilt 1987 · S/N 42-5527036 N722JWMcintosh Kenneth V · Pleasant Plain, OHBuilt 1962 · S/N 27-2040 N722WCS & T Aviation LLC · Missoula, MTS/N 31-8052166 N723JPTiffin Aire Inc · Tiffin, OHBuilt 1978 · S/N 31T-7920009 N723KYCommonwealth Of Kentucky · Frankfort, KYBuilt 1978 · S/N 31-7852122 N724VSTwin Oaks L & A Ltd · Wilmington, DEBuilt 1957 · S/N 23-869 N72553Whittom Ron W Jr · Wasilla, AKS/N 23-1031 N725RWGalante Holdings LLC · Altamont, ILS/N 31-7952187 N727HBRiverside Farms · Sardis, MSBuilt 1980 · S/N 31-8112006 N727MAMarc Inc · Bolton, MSBuilt 1976 · S/N 31-7652048 N727RLHammerton Kenneth R · Olive Branch, MSBuilt 1976 · S/N 31-7612056 N727TCSandpiper Air LLC · Dickinson, TXBuilt 1976 · S/N 27-7654107 N728CAPremiere Aviation Inc · Wilmington, DEBuilt 1976 · S/N 31-7752035

Back to AD 2009-13-06 R1