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.

N1764TTrabold Peter · North Adams, MABuilt 1970 · S/N 28-7125083 N1764VGross John F · Winthrop, MEBuilt 1974 · S/N 17263743 N1764XLeschber Larry · Hutto, TXBuilt 1975 · S/N 21060785 N17650Pynes Anthony P · Round Rock, TXBuilt 1977 · S/N D-9993 N17655Gray Stone Associates Inc · Knoxville, TNBuilt 1977 · S/N TC-2058 N17656Liddell Patrick A · Columbia Falls, MTBuilt 1977 · S/N D-9995 N1765GGivens Thomas A · Southern Pines, NCBuilt 1962 · S/N D-6964 N1765JMay Olivia G · Santa Rosa, CABuilt 1968 · S/N 28-24185 N1765MFlying Cow LLC · Syracuse, NYBuilt 1975 · S/N 18264430 N1765PHendry Robert L · Lysite, WYBuilt 1954 · S/N 18-4090 N1765RPlane Pro Aviation LLC · Shelby, NCBuilt 1978 · S/N R18200553 N1765TFlyhome Aviation LLC · Miami, OKBuilt 1970 · S/N 28-7125084 N1766Aftab Younus · Pleasanton, CAS/N NN-1 N17660Simpson Chad · Harrison, ARBuilt 1977 · S/N TH-810 N17668Broadway Travis A · Alexandria, LABuilt 1977 · S/N E-1001 N17669Srg Enterprises LLC · Montgomery, ALBuilt 1977 · S/N E-1002 N1766HOrlandi Properties LLC · Blairstown, NJBuilt 1959 · S/N 35866 N1766MN1776m LLC · Panama City, FLBuilt 1975 · S/N 18264431 N1766TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12110 N1766VCode4 Ventures Inc DBA · Waynesboro, VABuilt 1974 · S/N 17263744 N1767GFranceus Maurice Michael · Temperance, MIBuilt 1962 · S/N CD-539 N1767JHutcheson Jeffrey K · Council Bluffs, IABuilt 1968 · S/N 28-24188 N1767MAnderson Thomas C Trustee · Sun City West, AZBuilt 1975 · S/N 18264432 N1767RHamel David A · Klamath Falls, ORBuilt 1974 · S/N 18502487 N1767WN1767w LLC · Dover, DEBuilt 1972 · S/N TC-1500 N1768ERoyal Air Freight Inc · Waterford, MIBuilt 1978 · S/N 310R1566 N1768GRl Hoffman Aviation Services Inc · Sanders, KYBuilt 1962 · S/N CD-509 N1768JTrepanier Richard Alain · Benson, AZBuilt 1968 · S/N 28-24189 N1768TButler Thomas E · Arcadia, FLBuilt 1970 · S/N 28-7125087 N1768VBrown Craig D · Fort Wayne, INBuilt 1974 · S/N 17263745 N17692Starnes Robert D · Suwanee, GAS/N CE-700 N17698Spindel Stuart H · Hawesville, KYBuilt 1977 · S/N E-1005 N1769PVollendorf William M · Anchorage, AKBuilt 1954 · S/N 18-4107 N1769RCt Aviation LLC · Waverly, NEBuilt 1974 · S/N 18502489 N1769TCaudle Steve W · Glencoe, ALBuilt 1970 · S/N 28-7125088 N176ASkkaggs Erik · Tupelo, MSBuilt 2001 · S/N 60170 N176AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LABuilt 2025 · S/N 2881988 N176AZVincent T Remcho Phd LLC · Corvallis, ORBuilt 1983 · S/N 1027 N176BCCousins Mark T · Portland, ORS/N ME-269 N176BLChristiansen Aviation LLC · Wilmington, DEBuilt 2013 · S/N 172S11287 N176CMBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 2018 · S/N 4496427 N176DBBell Mary E · Cadillac, MIBuilt 1979 · S/N DB-76 N176DJTucker Christopher S · Mesa, AZBuilt 2010 · S/N 80107 N176GRDdx Air LLC · Wyomissing, PABuilt 1976 · S/N AA5B-0348 N176JBDecatur Aero Club Inc · Decatur, ILBuilt 1998 · S/N 2843183 N176LGillam Benjamin H · Acworth, GABuilt 2001 · S/N 142 N176LFFour Basics LLC · Olathe, KSBuilt 1977 · S/N E-1052 N176LGTita Enterprises LLC · Apex, NCS/N 172RG0074 N176LLClear Above LLC · Haymarket, VABuilt 1975 · S/N 21061135 N176MEEastern Cincinnati Aviation Inc · Batavia, OHBuilt 2000 · S/N 172S8470

Back to AD 2007-04-19 R1