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.

N9947WDwinal Gary Lee · Lisbon, MEBuilt 1967 · S/N 28-23492 N994BCEast Coast Flyers LLC · Rockville, MDBuilt 1970 · S/N 28R-7135036 N994CS994 Charlie Sierra Inc · Jacksonville, FLBuilt 1978 · S/N 28-7990089 N994FGFlightgest Academy LLC · Morrisville, NCBuilt 2024 · S/N 2881831 N994MBAquila Air Charter LLC · Wilmington, DEBuilt 1985 · S/N 28-8590037 N9950WPlane Jane Aviation LLC · Lincoln, NEBuilt 1967 · S/N 28-23495 N995AMPiper Aircraft Inc · Vero Beach, FLS/N 28010117 N995FGFlightgest Academy LLC · Morrisville, NCBuilt 2025 · S/N 2881883 N9961WViper Enterprises LLC · Rolla, MOBuilt 1967 · S/N 28-23508 N9962WSuggs Kaycen M · Grifton, NCBuilt 1967 · S/N 28-23509 N9964WRawlins James III · Saint Charles, MOBuilt 1967 · S/N 28-23511 N9966GN513pk Holdings LLC · Haverhill, MABuilt 2005 · S/N 3257370 N9968WWitter Gregory J · Overton, NVBuilt 1967 · S/N 28-23515 N996FGFlightgest Academy LLC · Morrisville, NCBuilt 2022 · S/N 2881598 N996JHMountain John · Wrightstown, WIBuilt 1971 · S/N 28-7125529 N9970WSkrabacz Joseph A · Niceville, FLBuilt 1967 · S/N 28-23517 N9971WMorris Elaine · Moorestown, NJBuilt 1967 · S/N 28-23518 N9975WPoole Terrell W · Rigby, IDBuilt 1967 · S/N 28-23523 N9977CSchuster Jacob M · Mchenry, ILBuilt 1972 · S/N 28-7225525 N9977WN9977w LLC · Easley, SCS/N 28-23525 N997CWDanesy Dorothea H · Pasadena, CABuilt 1977 · S/N 28-7716049 N997FGFlightgest Academy LLC · Morrisville, NCBuilt 2025 · S/N 2881954 N997JTRaskin Jamie · Staten Island, NYBuilt 1976 · S/N 32R-7680149 N997NCVega Gustavo E · Watertown, NYBuilt 1965 · S/N 28-20817 N997SGRas Aviation LLC · Elyria, OHBuilt 1978 · S/N 28-7816562 N9980WAll American Aviation Services Inc · Fayetteville, NCBuilt 1967 · S/N 28-23528 N9984WBlake David R · Sheridan, WYBuilt 1967 · S/N 28-23532 N9988WHanneman Michael W · Abilene, TXBuilt 1968 · S/N 28-24838 N9989WDnr Solutions LLC · Idaho Falls, IDBuilt 1967 · S/N 28-23537 N998CTCti Aircraft Leasing LLC · Memphis, TNS/N 2881297 N998FGFlightgest Academy LLC · Morrisville, NCBuilt 2025 · S/N 2881960 N998MAWarhawk LLC · Latrobe, PABuilt 1998 · S/N 3246105 N998MMHardcastle Eric · Holly Springs, NCBuilt 1968 · S/N 32-1035 N998PWBaker Toby J · Guthrie, OKBuilt 1979 · S/N 28-7911170 N9993WTalon Aviation LLC · Greenville, MIFirst renewal noticeS/N 28-23542 N999ABBentrup Reinhard · Goleta, CABuilt 1979 · S/N 32R-8029043 N999ADAllison Aviation LLC · Pueblo, COS/N 28R-7235117 N999ALFagerberg Albert P · Kerrville, TXBuilt 1978 · S/N 32R-7985009 N999CKBatla John D · Columbus, TXS/N 32R-7887177 N999CLCollette Dean R · Effingham, ILBuilt 1970 · S/N 28-5829 N999HSBurton John R · Punta Gorda, FLBuilt 1968 · S/N 28R-30716 N999KDKretschmer Fred L Jr · Vero Beach, FLS/N 28-7790181 N999KKStavang Herman Wayne Trustee · Snelling, CABuilt 1981 · S/N 28-8111073 N999LGZhou Aviation LLC · Lake Forest, CAS/N 3257131 N999MLesterville Land Holdings LLC · Ellington, MOS/N 32R-7885139 N999RJReschke William E · San Diego, CABuilt 1969 · S/N 28R-35169 N999TCCrenshaw Christopher · Canton, GABuilt 2004 · S/N 3257356 N999VFCrawford David B · Warren, OHBuilt 1971 · S/N 28R-7135143 N99BSEvans David M · Superior, WIBuilt 1977 · S/N 32R-7780432 N99DCCook Adam Richard · Lincoln, CABuilt 1977 · S/N 28R-7803109

Back to AD 87-08-08 R3