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.

N2181TAdk Flying Club Inc · Ballston Spa, NYBuilt 1971 · S/N 28-7205036 N21827Hall William B · Tabernacle, NJFirst renewal noticeBuilt 1972 · S/N 18801063 N2182BFlying 20 Club Inc · Springfield, ILBuilt 1978 · S/N 28-7990124 N2182CSkyhunter LLC · Yonkers, NYS/N 17702749 N2182FKleen Sheen IV LLC · Bowling Green, KYBuilt 2004 · S/N 18281340 N2182GCm Roberts LLC · Stratford, OKS/N 51482 N2182HSpangler & Pion LLC · Davis, CABuilt 1996 · S/N 29-0095 N2182LGadboys Jeffrey A · Naples, FLS/N TC-1996 N2182PSiemens Mark J · Rocklin, CABuilt 1976 · S/N 18264767 N2182QCassett Terry D · Mankato, MNBuilt 1979 · S/N 28-7990297 N2182RFoxley Brothers · Platte, SDBuilt 1964 · S/N 18256109 N2182SCimprich Michael J · Kirkland, WABuilt 1979 · S/N R18201311 N21832Shuman Cecil R Trustee · Chugiak, AKS/N 18503069 N21836C & S Development Services LLC · Weatherford, TXBuilt 1978 · S/N 32R-7885263 N2183ALee Christopher M · Port Jervis, NYBuilt 1999 · S/N 29-0198 N2183CVaughn Michael A Jr · Oxford, MIBuilt 1978 · S/N 17702750 N2183DLyons Terry L · Springfield, ILBuilt 1978 · S/N 28-7990163 N2183GBrinkman Jonathan D · Billings, MTS/N 51483 N2183JMichael Nehring Inc · Mohall, NDBuilt 2004 · S/N 172S9631 N2183KMaven Aviation LLC · Dillon, MTBuilt 1978 · S/N 32-7940022 N2183LDarfus Jason D · Tracy, CABuilt 1976 · S/N E-969 N2183MHayes William F · Philomath, ORBuilt 1979 · S/N 28-7911088 N2183TSkies Unlimited LLC · Clinton Township, MIBuilt 1971 · S/N 28-7205026 N2183ZCondor Enterprises Inc · Elkins Park, PABuilt 1979 · S/N 32-7940105 N21840Erickson Arnold F · Devils Tower, WYBuilt 1974 · S/N 17264031 N21841Erlinger Ronald W · Wickenburg, AZBuilt 1974 · S/N 17264032 N21843Robertson James D Trutee · Mountain View, CABuilt 2000 · S/N 29-0220 N2184BPlane Nonsense Inc · Middletown, DEBuilt 1978 · S/N 28-7990125 N2184DMeyer David J · Granbury, TXBuilt 1978 · S/N 32R-7985032 N2184FCarr Cassandra C · San Antonio, TXBuilt 1965 · S/N U206-0384 N2184NPlane Convenient LLC · Canton, OHBuilt 1999 · S/N 30-0039 N2184RHatbox LLC · Snohomish, WAS/N 18255384 N2184TFisher Global LLC · Conway, ARBuilt 1971 · S/N 28-7205028 N21852Peralta Jose Ramon · Sinking Spring, PAFirst renewal noticeBuilt 1972 · S/N 18801075 N21857Top Air · Salt Lake City, UTBuilt 1978 · S/N 28-7990062 N2185BHeirborne Again LLC · West Bridgewater, MABuilt 1978 · S/N 28-7990126 N2185EMckenzie Owen R Jr · Burlington, NCBuilt 1978 · S/N 17271182 N2185GGateway Flying Club Inc · Blaine, MNBuilt 1978 · S/N 32R-7985044 N2185KVandermeulen Jeffrey A · Pioneer, CABuilt 1978 · S/N 32R-7985061 N2185ULethin Savanna C · Anchorage, AKBuilt 1974 · S/N U20602354 N2185WHoward Pamela A · Goldthwaite, TXBuilt 1974 · S/N MB-696 N2185XHendricks Robert H · Chico, CABuilt 1979 · S/N 28-7990366 N21861Round Engine Aero · Nashville, MIS/N 18801082 N21866Donthineni Rakesh · Oakland, CABuilt 1978 · S/N 28-7990063 N2186DStevens Neil Richard · Moravia, NYBuilt 1953 · S/N D-3533 N2186FBranchaud Crystal J · Anchorage, AKBuilt 1965 · S/N U2060386 N2186JRsp Wealth Strategies LLC · Glen Allen, VABuilt 2000 · S/N 30-0047 N2186THutchins Christopher E · Venice, FLBuilt 1971 · S/N 28-7205038 N21870Tezaguic-Swanson Olga I · Wichita Falls, TXBuilt 1978 · S/N 28R-7837309 N21878Lie Chris E · Kotzebue, AKBuilt 1974 · S/N 17264038

Back to AD 2007-04-19 R1