Registered aircraft · 81,720

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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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:81-18-04-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
  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:81-18-04-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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.

N145TNewcomb Robert E · Greenfield, INBuilt 2021 · S/N 6-4971 N145WWWings Over Texas Holdings LLC · Denton, TXBuilt 2002 · S/N 4496145 N1460CMaki Tim J · Hibbing, MNBuilt 1953 · S/N 18-2659 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 N1461RDawson Electric Works Inc · Armstrong, IABuilt 1975 · S/N AA1B-0561 N1461TNiepert William · Jacksonville, NCBuilt 1972 · S/N 28-7225522 N1461UKettle Peter · Fitchburg, MABuilt 1976 · S/N 17267128 N14623Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 172S10430 N1462JWilson Donald R · Sterling, ILBuilt 1976 · S/N 462 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 N1464TSiedentopf Zyurelaie Indiana · Yelm, WABuilt 1972 · S/N 28-7205302 N1464XSymmetry Inc · Sarasota, FLBuilt 1975 · S/N 28-7515410 N1465ALarsen Caesar S · Pleasanton, CABuilt 1951 · S/N 22-372 N1465EDandelion Wine LLC · Charleston, SCBuilt 1978 · S/N 17271012 N1465JMartin Chris J · Zeeland, MIBuilt 1976 · S/N 465 N1465TCaudle Tommie A · Bentonville, ARBuilt 1972 · S/N 32-7200040 N14669Lowman Henry B Trustee · El Granada, CABuilt 2007 · S/N 172S10444 N1466CBent James L Jr DBA · Palatine Bridge, NYS/N 18-2668 N1466FGoody Birds LLC · Prattville, ALBuilt 1979 · S/N 17273005 N1466JLichman Robert P · Florence, SCBuilt 1976 · S/N 466 N1466UConcepcion Leonardo · Downey, CAS/N 17267133 N1466VGak Flight LLC · Scandia, MNBuilt 1974 · S/N 17263603 N1467CWeflen Arvid W · Fairbanks, AKBuilt 1953 · S/N 18-2682 N1467TThree2tango LLC · Mount Pleasant, SCBuilt 1972 · S/N 28-7205305 N1468EMachado Donald C Jr · Honolulu, HIBuilt 2007 · S/N 172S10446 N1468THindle John Charles IV · Whitehouse Station, NJBuilt 1972 · S/N 28R-7235296 N1468VMonmouth Flying Club · Monmouth, ILBuilt 1974 · S/N 17263605 N1469AJohnson Steven C · Cheyenne, WYBuilt 1952 · S/N 22-377 N1469TThree Wing Flight School LLC · Stratford, CTBuilt 1972 · S/N 28R-7235297 N146AAvila Edward V · Saint Johns, AZBuilt 2026 · S/N 90448 N146AMGospel Ministries International · Mc Donald, TNBuilt 2013 · S/N 0005918 N146AVVidal Aviation LLC · Gaithersburg, MDBuilt 1984 · S/N 28-8590010 N146CCRegistered aircraftBuilt 2004 · S/N 9970CC N146CZNiewiarowicz Michael J · Golden, COBuilt 2020 · S/N 1465 N146DFMara Taylor D · Mckinney, TXBuilt 2001 · S/N 60344 N146ECBulldog146llc · Longmont, COBuilt 1972 · S/N BH100/146 N146FAcrehood Air LLC · St Augustine, FLBuilt 2004 · S/N 18281437 N146HGMaloney Leasing LLC · Tupelo, MSS/N 3146 N146JPMartin John A · Grand Prairie, TXBuilt 2005 · S/N 40.481

Back to AD 81-18-04 R2