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.

N3961MBluebird Aviation LLC · Bismarck, NDBuilt 1978 · S/N 28-7816392 N3961RWhite Lightning 3961r LLC · Chandler, AZBuilt 1971 · S/N 28-7105066 N3961TMartin Noah R · Newcastle, CABuilt 1967 · S/N 28R-30306 N39626Drm Air Group Inc · Lewes, DEBuilt 1978 · S/N 32-7840171 N3962KFolsom Lawrence E · Millington, MDBuilt 1967 · S/N 28-23842 N3962RNifong James · Enterprise, ALBuilt 1971 · S/N 28-7105067 N3962TSilvretta LLC · Kalispell, MTBuilt 1967 · S/N 28R-30307 N39633Sandusky Aviation LLC · Edmond, OKBuilt 1978 · S/N 28-7916001 N39637Crawford Ted J DBA · Elma, IAS/N 32R-7887129 N39639Anselmi Alessandro · Cleveland, SCBuilt 1978 · S/N 32R-7887130 N3963TBlessing Stephen L · Bethany, MOS/N 28R-30309 N39646Icpc Craft LLC · Fremont, CABuilt 1978 · S/N 28R-7803358 N39647Pcl2 LLC · Menomonie, WIBuilt 1978 · S/N 32R-7885233 N3964RPerrin Gregory R · Vail, AZBuilt 1971 · S/N 28-7105069 N3964TFisher Joseph A · Conway, ARBuilt 1967 · S/N 28R-30310 N39650Bas Part Sales LLC · Greeley, COBuilt 1978 · S/N 32R-7887132 N39654Scarlet Peregrine LLC · Flagler Beach, FLBuilt 1978 · S/N 32R-7887134 N39659Ruijne Paul · Plainview, TXS/N 32R-7887136 N3965RRamsey Brian D · Van Nuys, CABuilt 1971 · S/N 28-7105070 N3965THudgin Louis B · Gilbert, AZBuilt 1967 · S/N 28R-30311 N3965XDevore Randall F · Prescott, IABuilt 1975 · S/N 28-7625002 N39660Your Mission LLC · Vinton, IABuilt 1978 · S/N 32R-7887142 N3966RBless Edward L Trustee · Hollister, CABuilt 1971 · S/N 28-7105072 N39671N39671 Aviation LLC · Wilmington, DEBuilt 1978 · S/N 32-7840175 N39673Signorino Joseph E Trustee · Bath, NCBuilt 1978 · S/N 32R-7887139 N3967KLakes Area Aero LLC · Pelican Rapids, MNS/N 28-23851 N39688N39688 LLC · Provo, UTBuilt 1978 · S/N 28-7990005 N3968KOzdogan Brent · Lawrenceville, NJBuilt 1967 · S/N 28-23852 N3968TService Oriented Aviation Readiness (S O A R) · Bolivar, MOBuilt 1967 · S/N 28R-30315 N3968WDiamond C Aviation Llcj · Gentry, ARBuilt 1967 · S/N 32-917 N39690Basin Ag Imaging LLC · Hermiston, ORBuilt 1978 · S/N 32R-7887145 N39697Goldsmith Ronald R · Mansfield, TXBuilt 1978 · S/N 28-7990007 N39698Komjathy Robert S · Brighton, MIBuilt 1978 · S/N 28-7990008 N3969KGrollimund David J · Pendleton, INS/N 28-23853 N3969WFix Edward L · Beavercreek, OHBuilt 1967 · S/N 32-909 N396AGSkywest Leasing Inc · St George, UTBuilt 1998 · S/N 28-43163 N396GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881175 N396LRRupiper Larry · Yankton, SDBuilt 1978 · S/N 32R-7885238 N39706Parks David V · Plant City, FLBuilt 1978 · S/N 32R-7887151 N39707Risley Gary Trustee · Farmington, NMBuilt 1978 · S/N 32R-7887118 N3970RRegistration Pending · Portland, ORRegistration pendingBuilt 1971 · S/N 28-7105075 N3970XStrand Stephen E · Pelican Rapids, MNBuilt 1975 · S/N 28-7515437 N39711Martin Mike · Carnesville, GABuilt 1978 · S/N 28-7990009 N39715Pierce Martin J · Muncie, INBuilt 1978 · S/N 28-7990010 N39718Wood Allan W · Santa Fe, NMBuilt 1978 · S/N 28R-7803359 N39719Pena Felix A · Salem, SCBuilt 1978 · S/N 32R-7887152 N3971KRegistered aircraftBuilt 1968 · S/N 28-23856 N3971RResnick Quinn A · Lake Park, FLBuilt 1966 · S/N 32-635 N3971WJma Aero LLC · Reedsville, PABuilt 1967 · S/N 32-881 N3972KPeak William G Jr · Westview, KYBuilt 1967 · S/N 28-23857

Back to AD 87-08-08 R3