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.

N157CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281857 N157CTCentral Texas College Aviation Science Dept · Killeen, TXBuilt 2024 · S/N 1037 N157DF157df LLC · Madison, WIS/N 17260646 N157DLSweet David L · Clovis, CABuilt 2010 · S/N 21079 N157FCDepartment Of Agriculture & Consummer Services · Tallahassee, FLBuilt 2006 · S/N 18281875 N157GSRegistered aircraftBuilt 1997 · S/N 20480 N157GWFoster Colt D · Eagle River, AKBuilt 1957 · S/N 18-6182 N157HPN344vg LLC · Princeton, NJBuilt 2006 · S/N 11057 N157HSFairbairn Travis J · Fort Worth, TXS/N 40634 N157JPParle John T · Thor, IABuilt 2000 · S/N 224 N157JRSoft Landings LLC · Myrtle Beach, SCBuilt 1991 · S/N TH-1639 N157KCNorthwestern Michigan College · Traverse City, MIBuilt 2010 · S/N 172S11037 N157LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842199 N157LMBaughman David · Jeffersonville, INBuilt 1961 · S/N 21057764 N157MAMaronick Richard · East Helena, MTBuilt 2012 · S/N 3167 N157MEMaine Coastal Flight Center Inc · Bangor, MEBuilt 2000 · S/N 172S8436 N157NNewsome Jeffrey S · Blackwell, OKBuilt 1976 · S/N TJ-52 N157PJCarnighan Kelly · New Albany, INBuilt 1946 · S/N 12-1152 N157RDedoming Russell C IV · Boylston, MABuilt 1991 · S/N CE-1636 N157RDBoman & Kemp Lc · Ogden, UTBuilt 1999 · S/N 18280646 N157RFAir Direct Holdings LLC · Stow, MABuilt 1967 · S/N 108 N157RJTdt Ag Support LLC · Brawley, CABuilt 1979 · S/N 28-7911168 N157RVJohnson Rian L · Portland, ORBuilt 2003 · S/N 70000 N157STogo Aviation Services LLC · Palmer, AKBuilt 1955 · S/N 31840 N157SCStone William E · Cusick, WABuilt 1957 · S/N 18-5997 N157SGRichland Aviation Inc · Sidney, MTBuilt 1973 · S/N 340-0154 N157TASpace Coast Aircraft Co · Meritt Island, FLBuilt 1998 · S/N 2842029 N157TBPerrin James F · Bancroft, WIBuilt 1997 · S/N 1389 N157TXHlebichuk David D · Montgomery, TXBuilt 2005 · S/N 1669 N157UUtah State University · Logan, UTBuilt 2025 · S/N 40.1253 N157VRoco Air LLC · San Antonio, TXBuilt 2005 · S/N 1472 N157WAUnited States Air Force - Owner · Hanscom Afb, MABuilt 2019 · S/N 2881157 N157WBBhh Leasing #4 LLC · Pensacola, FLBuilt 2014 · S/N 1139-2014 N157WMYale Companies LLC DBA · Indianapolis, INBuilt 2002 · S/N 4496157 N157YRosenberg Gordon W Trustee · San Ardo, CABuilt 1967 · S/N 1 N157ZLBrooks Aviation Inc · Douglas, GAS/N BG-355 N157ZZRegistered aircraftS/N 18280402 N15800Somd Aircraft Rentals And Instruction LLC · Leonardtown, MDBuilt 1972 · S/N 28-7325167 N15802Farias Wellington N · Hollis, NHS/N 28-7305146 N15804Lima Juliet LLC · Pearcy, ARBuilt 1972 · S/N 28-7305150 N15807Timmons Nathan M · Sarepta, LABuilt 1972 · S/N 28-7325168 N15808Dudek Henry · Clinton Township, MIBuilt 1972 · S/N 28-7325169 N1580EBermudez John M · Pembroke Pines, FLBuilt 1978 · S/N 17271051 N1580VPrecision Curbs And Concrete LLC · Shady Cove, ORS/N 17263696 N1580ZLiebmann Christopher J · Tehachapi, CABuilt 1961 · S/N D-6879 N158124 Bachelors LLC · Chesaning, MIS/N 28-7305152 N15814Alderson Collin · North Bend, NEBuilt 1972 · S/N 28R-7335094 N15819Brewer Les · Magna, UTS/N 28-7325170 N1581CFitzgerald Kenneth J · Millwood, WABuilt 1953 · S/N 30281 N1581GKovach Kenneth R · Jefferson, OHBuilt 1979 · S/N 310R1593

Back to AD 2007-04-19 R1