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.

N145HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2001 · S/N 172S8745 N145HPWalek Thomas E · Woodbury, MNBuilt 2003 · S/N NF0006 N145HRNeufeld Mark W · Coeur D Alene, IDBuilt 2007 · S/N 1778 N145JGGeldermann Bert E · Friday Harbor, WABuilt 2005 · S/N L2K-230 N145JKArcus Aero LLC · Bridgeport, TXBuilt 1965 · S/N 18051549 N145JMA&K Aviation LLC · Lambertville, MIBuilt 1980 · S/N D-10334 N145MTilley Steven E · Biddeford, MEBuilt 1977 · S/N D10061 N145MDBingham John R · Leawood, KSBuilt 2007 · S/N 755E N145MEAbdelmotal Elsadig · Pearland, TXBuilt 2000 · S/N 172S8429 N145MLKuonen Christopher · Wellsboro, PABuilt 1976 · S/N 17268382 N145PPainter Bryan J · Renton, WABuilt 1963 · S/N 205-0332 N145PDSpitzer Helicopter LLC · Wilmington, DEBuilt 2006 · S/N 11179 N145PLState Of Alaska · Anchorage, AKBuilt 1981 · S/N U20606141 N145RHFlying L Aircraft Inc · Fort Denaud, FLBuilt 1986 · S/N 1 N145RVColeman Ronald · Bastrop, TXBuilt 2011 · S/N 003 N145SWShore Gerry · Inez, TXBuilt 1973 · S/N 310Q-0614 N145TRRobinson Helicopter Co · Torrance, CABuilt 2026 · S/N 15020 N145TSBonanza A36 LLC · Wildwood, MOBuilt 1999 · S/N E-3235 N145TTVenture Air Solutions Inc · Dallas, GABuilt 1977 · S/N 402B1333 N145WWWings Over Texas Holdings LLC · Denton, TXBuilt 2002 · S/N 4496145 N145XBaron 55 LLC · Hutchinson, MNBuilt 1963 · S/N TC-507 N1460JMoore Ronnie G · Santa Fe, TXBuilt 1976 · S/N 460 N1460PBas Part Sales LLC · Greeley, COS/N 23-523 N1460XSimpson Arthur Lee · Richland Center, WIBuilt 1975 · S/N 28-7525293 N1461EOracle Aviation LLC · Omaha, NEBuilt 1978 · S/N 17271009 N1461JJanak Jeffrey · Corpus Christi, TXBuilt 1976 · S/N 461 N1461TNiepert William · Jacksonville, NCBuilt 1972 · S/N 28-7225522 N1461UKettle Peter · Fitchburg, MABuilt 1976 · S/N 17267128 N14621De Creeft Joseph M · Homer, AKBuilt 1951 · S/N 21056 N14623Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 172S10430 N1462JWilson Donald R · Sterling, ILBuilt 1976 · S/N 462 N1462SRiverside Aviation LLC · Oakland, IABuilt 1976 · S/N 18265009 N1462TWilliams Lesley J · Marquette, MIBuilt 1972 · S/N 28-7225523 N1462XVerbsky Douglas Collins · Frisco, TXBuilt 1975 · S/N 28-7525300 N1463E1463 Echo LLC · Eau Claire, WIS/N 17271010 N1463FSun Aircraft Management LLC · Ormond Beach, FLBuilt 2005 · S/N 172S9895 N1463PMarc Inc · Bolton, MSBuilt 1956 · S/N 23-526 N1463TN1463t LLC · Oak Hill, VABuilt 1972 · S/N 28-7225529 N1464CEdb Air Inc · Wilsonville, ORBuilt 2005 · S/N 172S9897 N1464ERegistration Pending · New Windsor, NYRegistration pendingBuilt 1978 · S/N 17271011 N1464GClauson Edward Ptrust · Charlestown, RIBuilt 1962 · S/N CD-468 N1464SRauch Andrew J · Timnath, COBuilt 1976 · S/N 18265011 N1464TSiedentopf Zyurelaie Indiana · Yelm, WABuilt 1972 · S/N 28-7205302 N1464XSymmetry Inc · Sarasota, FLBuilt 1975 · S/N 28-7515410 N1465EDandelion Wine LLC · Charleston, SCBuilt 1978 · S/N 17271012 N1465JMartin Chris J · Zeeland, MIBuilt 1976 · S/N 465 N1465MBig Mountain Construction LLC · La Grande, ORBuilt 1969 · S/N U20601465 N1465TCaudle Tommie A · Bentonville, ARBuilt 1972 · S/N 32-7200040 N14669Lowman Henry B Trustee · El Granada, CABuilt 2007 · S/N 172S10444 N1466FGoody Birds LLC · Prattville, ALBuilt 1979 · S/N 17273005

Back to AD 2007-04-19 R1