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.

N215RCGulf Coast Aviation LLC · New Orleans, LAS/N MA-89 N215RGGonzalez Rogiero A · San Antonio, TXBuilt 1979 · S/N 18266883 N215RRRednor Jeffrey · Yardley, PABuilt 2005 · S/N 1448 N215RVJet & Rotor Aviation LLC · Sacramento, CABuilt 1973 · S/N 67-73 N215RWUnderwood Darin M · Cedar Rapids, IABuilt 1995 · S/N E-2965 N215SMMyers Roy D · Naples, FLBuilt 2005 · S/N 81395 N215STNapoleon Christopher D · Allegany, NYBuilt 1967 · S/N 32-891 N215TGWatson William P · Durham, NCBuilt 2011 · S/N 001 N215TLLockard Theodore E Jr Trustee · Des Moines, IABuilt 2009 · S/N 40370 N215TWFreeze Timothy W · Waynesboro, VABuilt 2001 · S/N 198 N215UParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020136 N215WKaelberer Clyde · Montrose, MNBuilt 2017 · S/N 73013 N215YHodgson Mark · Fox Point, WIBuilt 1967 · S/N D-8495 N215ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881607 N21605Chandler Air Service Inc · Chandler, AZBuilt 1978 · S/N 28-7990054 N21608Mmt87 LLC · North Miami, FLBuilt 2003 · S/N 18281286 N2160DSamper Katherine · Miami, FLBuilt 2003 · S/N 172S9547 N2160JSnider Scott DBA · Turner, MTBuilt 1979 · S/N T18803397T N2160QSo Cal Leasing LLC · El Cajon, CAS/N 172S9546 N2160RPaper Plane LLC · Hotchkiss, COBuilt 1964 · S/N 18255360 N2160SGalkin Edwin N Dmd · Edison, NJBuilt 1975 · S/N 21061121 N2160THughes Johnny D · Meridian, MSS/N 28-7205010 N2160ZDodger Aircraft LLC · Lewes, DES/N 210 N21612Newbury Kirsten · Lake Oswego, ORS/N 30-0045 N21616Joseph Tamar Bar · Chanute, KSBuilt 1972 · S/N 18800910 N21618Schwend Brian · Forsyth, MTBuilt 1972 · S/N 18800912 N2161EBryn Terry P · Dazey, NDBuilt 1978 · S/N 17271172 N2161PRegistered aircraftBuilt 2004 · S/N 18281321 N2161RKlemme Aviation LLC · Davenport, IABuilt 1964 · S/N 18255361 N2161SRegistration Pending · Montezuma, NMRegistration pendingBuilt 1998 · S/N 290137 N2161WMatz Michael D · Hanna, INBuilt 1974 · S/N M-1551 N2161XLake Riley Aviation Inc · Excelsior, MNBuilt 1979 · S/N 32-7940088 N21625Simpson Aaron J · Fort Smith, ARBuilt 1998 · S/N 29-0170 N21626Low Level Aero LLC · Myakka City, FLS/N 18800917 N21627Beach David S Trustee · Amherst, NHBuilt 2004 · S/N 172S9575 N2162GOdiorne Bruce Lamar II · Durango, COBuilt 1958 · S/N 51462 N2162KApm Leasing LLC · Casper, WYBuilt 1978 · S/N 44-7995198 N2162LN2162l LLC · Tyler, TXBuilt 2005 · S/N 18281662 N2162PLark Aircraft Leasing · Port Townsend, WABuilt 1956 · S/N 23-764 N2162REndthoff Wayne K · Beloit, WIBuilt 1969 · S/N 28-5474 N2162TVolantis LLC · West Fargo, NDBuilt 1971 · S/N 28-7205012 N2162XTaylor Express Investments Inc · Wilmington, DES/N 32-7940089 N2162ZBaker Benjamin K · Anchorage, AKS/N 18051262 N21632Skyking 60 LLC · Tampa, FLBuilt 1999 · S/N 30-0006 N2163ASharp Roscoe A · Deer Park, WAS/N 20-891 N2163FSkywarrior Flight Training Inc · Pensacola, FLBuilt 1978 · S/N 44-7995167 N2163GWilson Willard III · Cannon Falls, MNBuilt 1978 · S/N 28-7990194 N2163JPortland Police Bureau · Portland, ORBuilt 2003 · S/N 18281279 N2163LS & S Southern Group Inc · Port Orange, FLS/N E-903 N2163PCarroll Bodo W · Franklin, OHBuilt 1956 · S/N 23-765

Back to AD 2007-04-19 R1