Skip to content

Registered aircraft · 8,139

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

N6383RZwiefelhofer Thomas J · Chetek, WIBuilt 1966 · S/N 28-21558 N6384WDigimas Edward · Bantam, CTBuilt 1964 · S/N 28-20449 N6385JMn Flight Holdings LLC · Plymouth, MNBuilt 1968 · S/N 28-4799 N6385WWilliams Michael R · Delbarton, WVS/N 28-20450 N6386JChoper Ethan J · Highland Park, NJBuilt 1968 · S/N 28-4800 N6387JTrammell Richard Z · Greenwood, SCBuilt 1968 · S/N 28-4801 N6387RSantaniello Joseph Benjamin · Miami Beach, FLBuilt 1966 · S/N 28-21564 N6388JRoman John C · Vacaville, CABuilt 1968 · S/N 28-4802 N6388WWebb Allen B · Perry, OKS/N 28-20453 N6389RShockwave Flight LLC · Keedysville, MDBuilt 1966 · S/N 28-21566 N638FLSale Reported · Sevierville, TNSale reported, pending cancellationBuilt 1971 · S/N 28-7125541 N6390JRoemer Dennis S · Holly, MIBuilt 1968 · S/N 28-4805 N6390WMitchell Christian P · Chico, CAS/N 28-20456 N6391RBarcelo Javier David · Royse City, TXBuilt 1966 · S/N 28-21568 N6392RRoberts Gage M · Steeleville, ILBuilt 1966 · S/N 28-21569 N6392WNebraska Indian Community College · Macy, NEBuilt 1964 · S/N 28-20458 N6393JCatherman Austin C · Chesterfield, VAS/N 28-4808 N6393WSchwartz Jay · Pembroke Pines, FLBuilt 1964 · S/N 28-20459 N6394JToman Peter · Cumming, GABuilt 1968 · S/N 28-4809 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 N63BASullivan Richard P · Star, IDBuilt 1963 · S/N 28-1494 N63FKHawley Robert W · Fort Worth, TXBuilt 1962 · S/N 28-757 N63GKRawareo LLC · Warsaw, MOS/N 28-20781 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 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 N6409RFly 365 Ltd · Montrose, COBuilt 1966 · S/N 28-21588 N6410JNoggle George · Bucyrus, OHBuilt 1968 · S/N 28-4827 N6411JPacific Union College · Angwin, CABuilt 1968 · S/N 28-4828 N6411WHis Promise Aviation Service · Big Spring, TXBuilt 1964 · S/N 28-20480 N6412WFlying Otter Aviation LLC · Snellville, GABuilt 1964 · S/N 28-20481 N6413RLee Dylan Robert · Portland, ORS/N 28-21592

Back to AD 96-10-01 R1