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.

N248CGStahura Conveyor Products Inc · Lewisville, NCBuilt 2001 · S/N 0092 N248DDevils Lake Aero Repair Inc · Devils Lake, NDBuilt 1966 · S/N TE-171 N248DBAce Helicopters LLC · Colfax, WIBuilt 1996 · S/N 0248 N248DGWhinery Kevin D · La Habra, CABuilt 2005 · S/N 1359 N248DLApple Hill Associates LLC · Dover, DEBuilt 2018 · S/N 14226 N248DMMontana 248dm LLC · Kalispell, MTBuilt 2002 · S/N 0374 N248ERUnverferth Gregory T · Fort Jennings, OHS/N 17271977 N248GFollett Enterprises LLC · Vlg Of Lakewd, ILBuilt 2005 · S/N 1261 N248GTHansen Nelse · Lawrenceville, GABuilt 1981 · S/N 17274572 N248HSLitchfield Lantz · Las Vegas, NVBuilt 1978 · S/N 21062726 N248JBRiverode Sales Inc · Pontiac, ILBuilt 1978 · S/N TC-2124 N248JWN248jw LLC · Sammamish, WABuilt 2023 · S/N 18283211 N248MHatton Wesley · Murrieta, CABuilt 1964 · S/N TC-558 N248MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881711 N248MMFouts Michael W · Canton, GAFirst renewal noticeBuilt 1995 · S/N 1248 N248RPPatterson Robert F · Buckley, WABuilt 1958 · S/N FM84-1 N248RVRossi John F · Newnan, GABuilt 2012 · S/N 80785 N248SFEl Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 172S13443 N248SHWaldron Aviation LLC · Fort Lauderdale, FLBuilt 2002 · S/N 0146 N248SWHicks James P · Franklin, OHBuilt 2013 · S/N 688 N248TFVisionary Holdings LLC · Missoula, MTBuilt 2025 · S/N 4496613 N248TTLohrman Lonny A · Wichita, KSBuilt 2018 · S/N 25408 N2490MDmld Corp · Wilmington, DEBuilt 1977 · S/N 28-7890254 N2490RBirdie Air LLC · Wichita, KSBuilt 1964 · S/N 18255590 N2490XFoley David A Trustee · Afton, WYBuilt 1965 · S/N 18256390 N2491GShowah Christopher Douglas · Indianola, MSS/N 51791 N2491QLong Daniel · Stevenson, ALBuilt 1966 · S/N 18257691 N2491RDaly John M · Fort Worth, TXBuilt 1964 · S/N 18255591 N2491TLichtman Bruce A · Stafford, VABuilt 1971 · S/N 28-7225078 N2491XBaalman Murray J · Grinnell, KSBuilt 1965 · S/N 18256391 N24928Hancock Carl M · Glendale, AZS/N 3543 N2492CTjossem Martin O · Paullina, IABuilt 1954 · S/N 30792 N2492SSierra Hotel Aircraft LLC · Wilmington, DEBuilt 1976 · S/N 21061302 N2492TOmni Aviation LLC · Pickerington, OHBuilt 1971 · S/N 28-7205060 N2492YBenham Charles D · San Angelo, TXBuilt 1968 · S/N E-74 N2493CBallard Bradley J · Youngsville, NCBuilt 1954 · S/N 30793 N2493QTarrant Enterprises Inc · Eagle, COBuilt 1966 · S/N 18257693 N2493XKoenig William T · Sauk Centre, MNBuilt 1965 · S/N 18256393 N2494EDuran Louis · Chino, CABuilt 1982 · S/N 18268207 N2494MJbbs Enterprises Inc · Middletown, DEBuilt 1977 · S/N 28-7890255 N2494QMcculloch Kyle · Bixby, OKBuilt 1966 · S/N 18257694 N2495Lynch Sean L · Brighton, ILBuilt 1978 · S/N 17270282 N2495FKalbfleisch George R · Dry Ridge, KYBuilt 1966 · S/N 18051697 N2495GHayton James B · Sedro Woolley, WABuilt 1959 · S/N 51795 N2495MPark Brian D · Springville, UTBuilt 1977 · S/N 28R-7837090 N2495RSale Reported · Saint Augustine, FLSale reported, canceledBuilt 1964 · S/N 18255595 N2495TAvia Flight Academy LLC · Stratford, CTBuilt 1971 · S/N 28-7205061 N2496FKrissman Ryan · Gallup, NMS/N 18051695 N2496MMorgan Jay · Fort Mill, SCBuilt 1977 · S/N 28R-7837091 N2496PTri M LLC · Nikiski, AKS/N 18-4305

Back to AD 2007-04-19 R1