Registered aircraft · 108,433

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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.

N2261LGaf Skyborne Aviation Ventures LLC · El Dorado Hills, CABuilt 1979 · S/N E-1535 N2261NLehrman Ronald L · Brownsburg, INBuilt 1994 · S/N 001 N2261QAndrews University · Berrien Springs, MIBuilt 1977 · S/N 28-7790386 N2261YKemper Dennis R · Carmichael, CABuilt 1967 · S/N 17700061 N2262DRcs Aeronautical Inc · San Antonio, TXS/N 1510 N2262FAnchor Aviation LLC · Blue Bell, PABuilt 1978 · S/N 28-7990074 N2262GRegistered aircraftBuilt 1946 · S/N 12-1183 N2262MAg Air Squadron Two LLC · Saint Joseph, ILBuilt 1977 · S/N 28-7816265 N2262QFirst Choice Insurance Partners LLC · Williamston, NCBuilt 1977 · S/N 28-7790387 N2262SKoch Phillip E · Eldon, MOBuilt 1976 · S/N 21061206 N2262TMarsh John E · Washington, DCBuilt 1968 · S/N 185-1420 N2262YRegistered aircraftBuilt 1967 · S/N 17700062 N2263CWalker William S · Shallotte, NCBuilt 1953 · S/N 30563 N2263QRoss Air Chicago LLC · Chicago, ILBuilt 1977 · S/N 28R-7737030 N2263TUnited States Air Force · Dover Afb, DEBuilt 1977 · S/N R18200014 N2263VSchanks William J · Saint Paul, MNBuilt 1985 · S/N 396 N2263YMejia Mauricio · South Gate, CABuilt 1967 · S/N 17700063 N22640Advanced Helicopter Concepts Inc · Frederick, MDS/N 0502 N2264GMessner Mark R · Chesapeake, OHBuilt 1958 · S/N 51564 N2264MArcher Aviation LLC · Orrtanna, PABuilt 1978 · S/N 28-7890237 N2264TTofik Mahir · Cumming, GAS/N 28-7125527 N2264UJanvrin Jerry M · Buffalo, SDS/N 426 N22650Sackett Gary G · Millcreek, UTFirst renewal noticeBuilt 1972 · S/N 21059767 N2265AAsher Kevin C · Wasilla, AKBuilt 1952 · S/N 18-1888 N2265FRegistration Pending · Wilmington, DERegistration pendingBuilt 1967 · S/N 310L-0065 N2265GWilder James S · Eagle, IDBuilt 1958 · S/N 51565 N2265MEik Baaz LLC · Rocklin, CABuilt 1977 · S/N 28-7890238 N2265TOracle Aviation LLC · Omaha, NEBuilt 1980 · S/N ME-333 N2265YHemann Dale F · Osage, IABuilt 1967 · S/N 17700065 N22669R S Bowen Enterprises LLC · Flowery Branch, GABuilt 2007 · S/N 18281942 N2266FTechnical Education Services Inc · Virginia Beach, VAS/N 310L-0066 N2266MGraves Robert E · Danville, INBuilt 1977 · S/N 28R-7837075 N2266SWeekend Air LLC · Incline Village, NVBuilt 1976 · S/N 21061210 N2266ZLobdell Robert T · Franklinville, NJBuilt 1979 · S/N 28-8090052 N2267AWilson Ronald W · Bluffton, SCBuilt 1969 · S/N D-9027 N2267YCole Gary L · Richmond, TXBuilt 1967 · S/N 17700067 N2268Hartley Linton H Jr · Loughman, FLBuilt 1972 · S/N HOW-100 N22689Ridge View Aviation LLC · Napanoch, NYBuilt 1974 · S/N 17264073 N2268AAerofeather Aviation Inc · Suffolk, VABuilt 1998 · S/N 17280686 N2268CCozach LLC · Wilmington, DEBuilt 1982 · S/N T30300081 N2268FKephart Peter J · Washington, MOBuilt 1966 · S/N 310L-0068 N2268MMorgan Kinder LLC · Friendswood, TXBuilt 2003 · S/N 0642 N2268SPlatinum Air Services LLC · Morgantown, WVS/N R18201317 N2268YMohr Marcia L DBA · New Richmond, WIBuilt 1964 · S/N 30-544 N2269HAerotranscendent Inc · Champaign, ILBuilt 1996 · S/N MK0212 N2269LLarrison Bryan J · Dublin, OHBuilt 1972 · S/N AA5-0156 N2269PBlackwell Steve · Lewisburg, TNBuilt 1966 · S/N 670152 N2269QN2269q LLC · West Palm Beach, FLS/N 28-7725189 N226ACTitle 46 LLC · Hamilton, MTBuilt 1979 · S/N 18267019 N226ADDercole Anthony · Bowden, GABuilt 1967 · S/N 680076

Back to AD 2007-04-19 R1