Registered aircraft · 108,428

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.

N1814SUnited Mobile Auctions Aviation LLC · Mooresville, NCBuilt 1981 · S/N E-1883 N1814VBeyer Leasing Co · Paw Paw, MIS/N 17263759 N18159Beck Thomas G · Walled Lake, MIBuilt 1976 · S/N 17702534 N1815DOdell Ryan S · Yukon, OKS/N D-10376 N1815FIss Holdings LLC · Lady Lake, FLBuilt 1981 · S/N E-1886 N1815GGalaxy Aviation LLC · Nantucket, MABuilt 1981 · S/N D-10379 N1815HPlane Fun Inc Tr Trustee · Snellville, GABuilt 1976 · S/N 21061148 N1815JDodson International Parts Inc · Rantoul, KSBuilt 1968 · S/N 28-24244 N1815LEagles Rise Aviation LLC · Wales, MAS/N TJ-63 N1815ROsprey Island Lodge Inc · Eagle River, AKBuilt 1974 · S/N 18502530 N1816FMalcom Scott O · Toledo, WABuilt 1965 · S/N 21058716 N1816HKiever Robert P · Summerland Key, FLBuilt 1959 · S/N 35916 N1816JWakefield Aircraft LLC · Cooperstown, NDS/N 182-68574 N1816RArizona Game & Fish Dept · Phoenix, AZBuilt 1974 · S/N 18502531 N1816TGq Aviation LLC · Cherry Hill, NJBuilt 1971 · S/N 28-7125173 N1816ZWestern Anesthesia Assn · Richland, WABuilt 1981 · S/N M-232 N18174Connell William J · Woodinville, WABuilt 1976 · S/N 17702535 N1817AKlinefelter Kristopher J · Phoenix, AZBuilt 1981 · S/N EA-243 N1817EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12169 N1817JCarey Thomas W Jr · Springfield, ILBuilt 1968 · S/N 28-24247 N1817LLorenzo Timothy A · Eureka, CABuilt 1976 · S/N E-839 N1817RLfg Properties LLC · Portage, MIS/N R18200571 N1817SClear Skies LLC · Stuart, FLBuilt 1981 · S/N TH-1271 N1817TR J Services LLC · Centerton, ARBuilt 1971 · S/N 28-7105142 N1817XSale Reported · Roseville, MNSale reported, pending cancellationBuilt 1965 · S/N 18255917 N1817ZOrr Lynn E · Fredericksburg, OHBuilt 1981 · S/N TJ-386 N18182Samaha Fadi · Point Roberts, WABuilt 1975 · S/N 18263913 N18184Lerille Red · Lafayette, LABuilt 1941 · S/N A-810 N18186Davies Samuel R · Port Angeles, WAS/N A-812 N1818AMaas Nancy C · Redding, CABuilt 1978 · S/N 18266532 N1818JDavey Aaron A · Topeka, KSBuilt 1968 · S/N 28-24248 N1818RSideline Services LLC · Pearland, TXBuilt 1978 · S/N R18200572 N1818TCopp Gary P · Carson City, MIBuilt 1971 · S/N 28-7105143 N1818XBeech Jet 324 LLC · Delray Beach, FLBuilt 2000 · S/N E-3302 N1818YLemonides Charles S · Bridgehampton, NYBuilt 1981 · S/N E-1888 N1819Peters Sean T · Oak Harbor, OHBuilt 1959 · S/N 22-6705 N18190Miller Chad A · Many, LAS/N TC-2403 N1819BDudinsky Todd M · Eagle River, AKS/N 20008C N1819DSpeedcraft Industries LLC · Port Jefferson, NYBuilt 2020 · S/N 1188-2020 N1819GRandall Robert N Jr · Burnsville, MNBuilt 1983 · S/N R182-01819 N1819LBlack Kettle Inn LLC · Cabool, MOS/N E-838 N1819MDjb Asset Management LLC · Oakdale, CABuilt 1981 · S/N EA-245 N1819XGrant Steven T · Sellers, SCBuilt 1964 · S/N 18255919 N181AHightower Andrew · Saint Paul, MNBuilt 2003 · S/N 60280 N181ACTwo Tall Tamaracks LLC · Ovando, MTBuilt 1980 · S/N CE-914 N181AFSmoketown Helicopters LLC · Smoketown, PABuilt 2010 · S/N 2100 N181AKWeflen Arvid W · Fairbanks, AKBuilt 1992 · S/N W1991 N181ATNazario Rafael · Delray Beach, FLBuilt 1973 · S/N 18262686 N181AVElkins Pilots Club · Elkins, WVBuilt 1979 · S/N 287990269 N181BAClough James Erwin · Pittsboro, NCBuilt 1981 · S/N 28-8116230

Back to AD 2007-04-19 R1