Skip to content

Registered aircraft · 22,413

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.

N6392RRoberts Gage M · Steeleville, ILBuilt 1966 · S/N 28-21569 N6392WNebraska Indian Community College · Macy, NEBuilt 1964 · S/N 28-20458 N6393CInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 28-7816419 N6393JCatherman Austin C · Chesterfield, VAS/N 28-4808 N6393WSchwartz Jay · Pembroke Pines, FLBuilt 1964 · S/N 28-20459 N6394CAtd Pilot Training LLC · Kansas City, MOBuilt 1978 · S/N 28-7816420 N6394JToman Peter · Cumming, GABuilt 1968 · S/N 28-4809 N6395CVirnig Joshua · Deerwood, MNBuilt 1978 · S/N 28-7890370 N6395JSheffield Samuel D · Cartersville, GABuilt 1968 · S/N 28-4810 N6395RFoundation Of Wayne Community College Inc · Goldsboro, NCBuilt 1966 · S/N 28-21572 N6395WByers Brent L · Sarcoxie, MOBuilt 1964 · S/N 28-20461 N6396RBaumler George C · Louisville, KYBuilt 1966 · S/N 28-21573 N6396WMadron Raymond P · Rising Sun, MDBuilt 1964 · S/N 28-20462 N6397JWipf Travis D · Billings, MTBuilt 1968 · S/N 28-4812 N6397RGoodman Creighton A · Lake Havasu City, AZBuilt 1966 · S/N 28-21574 N6398JSanger Mark D · Dana Point, CABuilt 1968 · S/N 28-4813 N6398RLindemann Steven M · Colorado Springs, COBuilt 1966 · S/N 28-21575 N6399CRomanowski Mark Steven II · Clay, MIBuilt 1978 · S/N 28R-7803226 N639FTFlorida Institute Of Technology · Melbourne, FLBuilt 2008 · S/N 2842316 N639MRBean Timothy S · Myrtle Beach, SCBuilt 1975 · S/N 28-7515293 N639STVector Aviation LLC · Mentor, OHBuilt 2006 · S/N 2843639 N63AJSehgal Aviation Inc · Shoreline, WABuilt 2003 · S/N 3255003 N63BASullivan Richard P · Star, IDBuilt 1963 · S/N 28-1494 N63BTSilverback Solutions LLC · Amlin, OHBuilt 1976 · S/N 32R-7680094 N63FKHawley Robert W · Fort Worth, TXBuilt 1962 · S/N 28-757 N63GKRawareo LLC · Warsaw, MOS/N 28-20781 N63PEGoodinson Marc D · Hamburg, NJBuilt 1968 · S/N 28R-30908 N63PFCti Aircraft Leasing LLC · Memphis, TNS/N 2881300 N63PLBoeing Employees Flying Club St Louis Inc · Saint Louis, MOBuilt 1977 · S/N 28-7816263 N63PVAir Tech Flying Club Inc · Chesterfield, VABuilt 1994 · S/N 3213087 N63RLVolland Aimee C · Tavernier, FLBuilt 1976 · S/N 28R-7635368 N6400WRegistration Pending · Los Osos, CARegistration pendingBuilt 1964 · S/N 28-20468 N6401JMccarthy J Patrick · Pleasanton, CABuilt 1968 · S/N 28-4817 N6401RNorthern Prairie Sky LLC · Erskine, MNBuilt 1966 · S/N 28-21579 N6403CSherwood Jeffrey J · Sacramento, CAS/N 28R-7803227 N6403JDog House Aviation LLC · Houston, TXBuilt 1968 · S/N 28-4819 N6403WDanford Scott M · Chickamauga, GAS/N 28-20471 N6404JMorgan Donelle C · Cambria, CABuilt 1968 · S/N 28-4820 N6405JTubesing Gordon Earl Trustee · Palm Coast, FLBuilt 1968 · S/N 28-4821 N6405WNightline Air LLC · Saratoga Springs, UTBuilt 1964 · S/N 28-20473 N6406JAntonovich Thomas W · Mesa, AZBuilt 1968 · S/N 28-4823 N6407JSleepy Creek Farm - Ga LLC · Gray, GABuilt 1968 · S/N 28-4824 N6407RKubisiak Steven F · Amherst, WIBuilt 1966 · S/N 28-21586 N6407WDoeden Patricia · Hillsborough, NCBuilt 1964 · S/N 28-20476 N6408JGish David L · Mooresville, NCBuilt 1968 · S/N 28-4825 N6409CCrider Richard S · Prescott, AZS/N 32-7840083 N6409RFly 365 Ltd · Montrose, COBuilt 1966 · S/N 28-21588 N640FTFlorida Institute Of Technology · Melbourne, FLBuilt 2008 · S/N 2842317 N640NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881145 N640TCWingsleasing LLC · Wichita, KSS/N 2843491

Back to AD 87-08-08 R3