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.

N76SRTangipahoa Mosquito Abatement District # 1 · Hammond, LABuilt 1972 · S/N 27-7304976 N770BKHorizon Dreams LLC · Homer, GABuilt 1969 · S/N 27-4296 N770KTInterprime Air Inc · Doral, FLBuilt 1975 · S/N 31-7552053 N770MGPlan Bee LLC · Washington, DCS/N 31T7520029 N7711MStauffer Michael S · Wichita Falls, TXBuilt 1965 · S/N 27-2936 N7718AScud Air 18a LLC · Morgan, UTBuilt 1975 · S/N 27-7554040 N772DLClik Services LLC · Forestdale, MABuilt 1981 · S/N 318152007 N773PTRegent Trust Co Trustee · Wichita, KSBuilt 1973 · S/N 27-7305144 N774CERegistration Pending · Saint Paul, MNRegistration pendingS/N 31-7712047 N774KVTjr Aviation LLC · Allentown, PABuilt 1982 · S/N 31T-8166057 N775RAMojave 775ra LLC · Roseburg, ORBuilt 1982 · S/N 31P8414038 N775TSSmith Paul A · Trufant, MIBuilt 1976 · S/N 27-7654069 N776MCCrew Sourcing Inc · Wilmington, DEBuilt 1957 · S/N 23-1078 N776WBcww LLC · Bakersfield, CABuilt 1980 · S/N 31-8052165 N777HZCb Auto Inc · Columbia, MDS/N 31-7405177 N777JYKingslyn Ltd · Wilmington, DEBuilt 1978 · S/N 31-7912004 N777MEDe La Garza De La Fuente Jose A · Montgomery, TXBuilt 1980 · S/N 31-8012049 N777VZFreeman Brooks · Richmond, VABuilt 1981 · S/N 31-8212012 N777ZMFriar Aerospace Group LLC · Dover, DEBuilt 1980 · S/N 31-8052193 N778SGValiair Ltd Co Trustee · Casper, WYBuilt 1983 · S/N 42-5501006 N779MRRock N Robins Flying Service LLC · Palm City, FLBuilt 1976 · S/N 27-7654047 N77DSBalderas Alberto · Harlingen, TXS/N 317812061 N77KKMensch Aviation LLC · Hastings, MIBuilt 1980 · S/N 278154002 N77KTRochna Stephen J · Fallon, NVBuilt 1958 · S/N 23-1306 N77NLNew South Inc · Charleston, SCBuilt 1977 · S/N 31T-7720038 N77YACrew Sourcing Inc · Wilmington, DEBuilt 1954 · S/N 23-61 N780GCAir Eye Md LLC · Carolina, PRBuilt 1978 · S/N 317812069 N7812MAerial Farmer LLC · Missoula, MTS/N 27-3508 N781CKSnowy Owl Aviation LLC · Charlottesville, VABuilt 1978 · S/N 31T-7820056 N7827SStar Aviation Inc · Melville, NYBuilt 1982 · S/N 31-8252035 N78329Tindall William M · Pensacola, FLS/N 27-2329 N783BZJsaz LLC · North Little Rock, ARS/N 31-7305018 N7842BLowe David M · Sacramento, KYBuilt 1956 · S/N 23-632 N787RWJw Venture Aviation LLC · Concord, NCS/N 31-7652087 N78GHCustom Air International LLC · Homestead, FLBuilt 1978 · S/N 31-7852121 N78GSAir Mods And Repair Corp · Robbinsville, NJBuilt 1972 · S/N 27-4833 N78JT71793 LLC · San Luis Obispo, CABuilt 1978 · S/N 27-7854138 N78LJValiair Lc · Casper, WYBuilt 1973 · S/N 27-7304943 N78MSDibenedetto Todd P · Riverwoods, ILS/N 31-7812074 N790BBBeitel Robert R · Lake Wylie, SCBuilt 1968 · S/N 27-4023 N796AATechnical Education Services Inc · Virginia Beach, VABuilt 1977 · S/N 27-7854036 N797VCSantana Carlos A · San Juan, PRBuilt 1966 · S/N 27-3439 N79HLIndiana Paging Network Inc · Laporte, INS/N 27-7954046 N79LDTcb Aviation LLC · Evansville, INBuilt 1982 · S/N 31-8252062 N79LKGonzalez Leon · Pembroke Pines, FLBuilt 1980 · S/N 31-8012092 N79MFSkyking Aviation Services LLC · Carson City, NVBuilt 1979 · S/N 27-7954098 N7AZDevaney Aviation Inc · Palm City, FLBuilt 1968 · S/N 27-3964 N7CBExperimental Aircraft Association · Oshkosh, WIBuilt 1972 · S/N 27-4802 N7FLCentral Virginia Aviation Inc · Petersburg, VABuilt 1978 · S/N 31T-7820082 N7HWAltieri Frank J · Somerton, AZBuilt 1967 · S/N 27-3718

Back to AD 2009-13-06 R1