Skip to content

Registered aircraft · 22,416

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

N9431COsgood Air LLC · Ransom, KSBuilt 1978 · S/N 28-7890411 N9431JCurrie Kenneth Edward · Lumberton, NCBuilt 1966 · S/N 28-3542 N9433JSierra Delta Aviation Services Inc · Middletown, DEBuilt 1966 · S/N 28-3545 N9433WSanford William M · Olalla, WABuilt 1968 · S/N 28-11141 N9434JSchmidt Matthew F · River Falls, WIBuilt 1966 · S/N 28-3546 N9434WJohnson James E · Calhoun, LAS/N VE-7711 N9435JHarmon Daniel J · Sheridan, INBuilt 1966 · S/N 28-3547 N9435NDoran Jeffrey · Centerburg, OHS/N 28R-35148 N9435WPace Lawrence W · Westminster, COBuilt 1968 · S/N 28-11145 N9436WGiesbrecht Harley L · Deridder, LABuilt 1968 · S/N 28-11153 N9437JGarba Ibrahim I · Boulder City, NVBuilt 1966 · S/N 28-3549 N9437WEscher Charles W · Terrell, TXBuilt 1969 · S/N 28-11242 N9439KAirspeed Marketing Bravo LLC · Phoenix, AZBuilt 1976 · S/N 28-7625180 N9439WCherokee Ltd LLC · Mesa, AZBuilt 1967 · S/N 28-11151 N943HSMonika Aviation LLC · Humble, TXBuilt 1978 · S/N 32R-7887062 N943NDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881922 N943RGSegal Briar N Trustee · Tucson, AZBuilt 1979 · S/N 28-7921049 N943ZTTcheutchua Romeo J · Olathe, KSS/N 28-21937 N9440JDeascentis Dean · Lincoln, CAS/N 28-3552 N9440NEshowe Aviation Inc · East Peoria, ILBuilt 1969 · S/N 28R-35154 N9440WLicausi Dan · Cathedral City, CABuilt 1968 · S/N 28-11155 N9441WBaker Carl · Angleton, TXBuilt 1968 · S/N 28-11157 N9442CElevate Aviation LLC · Rathdrum, IDBuilt 1978 · S/N 32-7840098 N9442NClear2aviate LLC · Ionia, MIBuilt 1969 · S/N 28R-35156 N94435Gibler Robert R · Peachtree City, GABuilt 1972 · S/N 287225072 N9443NSchulz John B Jr · Marquette, MIBuilt 1969 · S/N 28R-35157 N9443WC H Draw Co Inc · Park City, KSBuilt 1968 · S/N 28-11161 N9444WMacedo Carlos C · Dayton, OHBuilt 1969 · S/N 28-11163 N9445JRamey Austin B · Salida, CABuilt 1966 · S/N 28-3557 N9445KAishvaryam LLC DBA · Lancaster, TXBuilt 1976 · S/N 28-7615203 N9445WEnglund Gary · Goldendale, WABuilt 1969 · S/N 28-11164 N9446JFitch Stephen C · Moreno Valley, CABuilt 1966 · S/N 28-3558 N9447NEvans Jeff W · Hannibal, MOBuilt 1969 · S/N 28R-35162 N9447WZiemann Mark · Camp Verde, AZBuilt 1969 · S/N 28-11166 N9448JRichmond Heights LLC · Pocahontas, ARBuilt 1966 · S/N 28-3560 N9448NMason Harold R · Quincy, WABuilt 1969 · S/N 28R-35163 N9448WKlein Richard J · Greenville, MIBuilt 1969 · S/N 28-11167 N9449NCole Vincent J · Ewa Beach, HIFirst renewal noticeBuilt 1969 · S/N 28R-35164 N9449WProfessional Pilots Inc · Lowell, INBuilt 1968 · S/N 28-11168 N944DBManning David A · Aledo, TXS/N 2844109 N944DGMattingly Mathew · St Simons Island, GABuilt 1965 · S/N 28-2850 N944EVSouthlake Aviation LLC · Arden, NCBuilt 2025 · S/N 2881867 N9450JNorthwood Aviators · Northwood, NDS/N 28-3563 N9450WAirwide LLC · Deerwood, MNBuilt 1968 · S/N 28-11169 N9451JJackson James E · Denair, CABuilt 1966 · S/N 28-3564 N9451NHorus Aviation LLC · Ashburn, VABuilt 1969 · S/N 28R-35166 N9452CFarris James R Jr · New Castle, PABuilt 1978 · S/N 32R-7887006 N9452WMarshall Duane C · Rossville, TNS/N 28-11171 N9453JStarbard Donald · Crystal Bay, NVBuilt 1966 · S/N 28-3566 N9453NBroody George E Jr · Berwick, PABuilt 1969 · S/N 28R-35168

Back to AD 87-08-08 R3