Registered aircraft · 81,733

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.

N4295RGhost Riders Aoo LLC · Altoona, PABuilt 1983 · S/N 28-8311014 N4295VMcmahon Ian R · Locust Grove, GAS/N 71732 N4296HBogart Sean A · Anchorage, AKBuilt 1948 · S/N 14-99 N4296MFowler Garry E · Post Falls, IDS/N 12-3228 N4296NScholz Daniel Joseph · Mantorville, MNBuilt 1983 · S/N 32-8306021 N4296PInvestair LLC · Conway, ARBuilt 1959 · S/N 23-1796 N4296QAirjohn LLC · Cheyenne, WYBuilt 1971 · S/N 17260196 N4296SB J Air Inc · Wilmington, DEBuilt 1983 · S/N 32-8306022 N4296ZSisk Michael Shaun · Steamboat Springs, COBuilt 1967 · S/N 18-8548 N4297ASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1971 · S/N 39-114 N4297HAirswiss Inc · Wilmington, DEBuilt 1978 · S/N 24-0699 N4297MInternational Air Services Inc Trustee · Carson City, NVBuilt 1983 · S/N 28-8316056 N4297QCritchfield David P · Paradise, CAS/N 17260197 N4297ZAcadiana Cub LLC · Abbeville, LAS/N 18-8549 N42982Dassin Andre · Altadena, CABuilt 1983 · S/N 28-8390050 N42985Hall Jason · Iron Mountain, MIBuilt 1983 · S/N 32-8306023 N42987Gman Air LLC · Clayton, MOBuilt 1983 · S/N 32R-8313017 N4298EParish Matthew G · Drummonds, TNBuilt 1978 · S/N 38-78A0535 N4298LToon Corey A · Carthage, TXBuilt 1983 · S/N 28-8316058 N4298QDarrach Todd I · Rhome, TXS/N 17260198 N4298ZAugustine Ryan M · Talkeetna, AKBuilt 1967 · S/N 18-8555 N4299HCompton James D · Griffin, GABuilt 1948 · S/N 14-103 N4299PAllison Daniel H · Whittier, NCBuilt 1959 · S/N 23-1799 N4299ZKauffman Loren C · Anchor Point, AKS/N 18-8558 N429ACRegistration Pending · Morris, ILRegistration pendingBuilt 1999 · S/N 429-99 N429AMAero Mark Inc · Idaho Falls, IDBuilt 2007 · S/N 2429 N429BJJohnston Richard Max Trustee · Sierra Madre, CAS/N 40410 N429CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 2001 · S/N 172S8691 N429DRConard John C · Minnetonka, MNS/N 60412 N429EGCongalton Steve M · Rancho Cucamonga, CABuilt 1974 · S/N 28-7405188 N429EPBbm Air LLC · Macon, GAFirst renewal noticeBuilt 2001 · S/N 17280608 N429ESBarbers Point Flight School LLC · Kapolei, HIBuilt 1997 · S/N 17280296 N429FFDhs Operations LLC · Wilmington, DEBuilt 2004 · S/N 17281229 N429HCourreges Ryan · Wheat Ridge, COBuilt 2004 · S/N 470 N429JPHnb Aviation LLC · Forestburg, TXBuilt 2007 · S/N 18281955 N429KERegistered aircraftBuilt 1998 · S/N 52352 N429LChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11452 N429MVSacandaga Air Inc · Fort Plain, NYBuilt 2007 · S/N CC18-0021 N429PXPaxton Garry A · Tavares, FLBuilt 2012 · S/N SFG 021 N429RVEvans Logan R · Livermore, CAS/N 72096 N429SFLewis Jason M · Camden, ARBuilt 1979 · S/N 32-7940136 N429TYancey Michael E · Brighton, TNBuilt 1981 · S/N 688 N429TWWebb Thomas M · Nine Mile Falls, WABuilt 2007 · S/N 1550 N42AGBeck William J · Phoenix, AZS/N 28-7110014 N42AHRegistered aircraftBuilt 2005 · S/N 40241 N42AKGerhardt David · Denver, COBuilt 1998 · S/N 1434 N42APMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1977 · S/N 17269941 N42ARAtlantic Aircraft Holdings LLC · Bohemia, NYBuilt 1979 · S/N AA5B1285 N42BLRainey Steven M · Rosamond, CAFirst renewal noticeBuilt 2003 · S/N 2899 N42BUUnrein Brian L · Conyers, GABuilt 2012 · S/N 1337

Back to AD 81-18-04 R2