Skip to content

Registered aircraft · 68,375

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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.

N26717Dumpling Girls LLC · Concord, NCBuilt 1978 · S/N AA5A0671 N26718Owen James T · Broken Arrow, OKS/N AA5A0673 N26719Orlandi Properties LLC · Blairstown, NJBuilt 1940 · S/N 4140 N2671GAas LLC · Ovid, MIBuilt 1967 · S/N 316 N2671MZoch Lori R · Port Orange, FLBuilt 1946 · S/N 12-972 N2671WSchwister Daniel Edward · Woodinville, WABuilt 1966 · S/N 3315 N26722Neutren Glenn · Fort Bragg, CABuilt 1978 · S/N AA5A0675 N26723Fulcrum Software Corp · Raleigh, NCBuilt 1978 · S/N AA5A0676 N26725Registered aircraftS/N AA5A0678 N26728Schmicker Robert A · Edmond, OKBuilt 1978 · S/N AA5A0680 N2672Q4m Aviation LLC · Orting, WABuilt 1977 · S/N 28R-7737040 N2672VWhite Robe · Castro Valley, CABuilt 1974 · S/N 177RG0649 N2672WGallatin Aviation Enthusiasts LLC · Fairbanks, AKBuilt 1966 · S/N 3316 N2672ZPuma Applied Science · Winchester, CABuilt 1977 · S/N 1007-78 N26733Givens Eric J · Frankfort, OHBuilt 1978 · S/N AA5A0605 N26737Noser Thomas C · Bowling Green, KYBuilt 1978 · S/N AA5A0683 N26738Hardy David G · Gilbert, SCBuilt 1978 · S/N AA5A0684 N2673AWilde Air Service LLC · Volga, SDBuilt 1953 · S/N 22-933 N2673VJackson R N · Southlake, TXBuilt 1974 · S/N 177RG0650 N2673WAdolf Charles P · Ocala, FLBuilt 1966 · S/N 996 N26743Lian Jay · Gold Beach, ORBuilt 1978 · S/N AA5A0686 N26744Flying Tigers Flight School Ltd · Houston, TXBuilt 1978 · S/N AA5A0688 N2674MStarr LLC · Superior, WIBuilt 1946 · S/N 12-1107 N2674TCosgrove John W · Lake Ariel, PABuilt 1971 · S/N 28-7205075 N2674VMoroil Corp · Davidson, NCBuilt 1974 · S/N 177RG0651 N2674WHough Publishing LLC · Atlanta, GABuilt 1966 · S/N 997 N26757Terranova Jay · Lawrenceville, GAS/N AA5A0695 N26758Cooley Carolyn A · Bonifay, FLBuilt 1978 · S/N AA5A0696 N2675DPaige Barry Wayne · Wasilla, AKBuilt 1952 · S/N 20827 N2675TMahoney Dustin G · Lakewood, COBuilt 1971 · S/N 28-7225084 N26760Davis Dana J · Pismo Beach, CABuilt 1978 · S/N AA5A0699 N26768Cheetah268 LLC · Kailua Kona, HIBuilt 1978 · S/N AA5A0704 N26769Cascade Aerial Services LLC · Chehalis, WABuilt 1940 · S/N 4165 N2676TMills Nicolas A · Greenwood, NYBuilt 1971 · S/N 28-7205074 N2676ZFlynn Steven W · Bushnell, FLBuilt 1977 · S/N 1008-78 N26770Tuan Vo · Falls Church, VABuilt 1978 · S/N AA5A0705 N26778N26778 LLC · Santa Monica, CABuilt 1978 · S/N AA5A0714 N2677ML & L Farms · Richvale, CABuilt 1946 · S/N 12-1095 N2677TDaggett Truck Lines Inc · Frazee, MNBuilt 1971 · S/N 28-7205077 N2677WSaunders Charles A · Scott Depot, WVBuilt 1966 · S/N 3318 N2677ZWillkris Aviation Services LLC · Smithfield, VAS/N 1018-78 N26780Campbell Joseph · Niceville, FLBuilt 1978 · S/N AA5A0715 N26781Landon Easton Jeffrey Allen · Dresden, TNBuilt 1978 · S/N AA5A0716 N26784Texas Cheetah LLC · Sugar Land, TXS/N AA5A0717 N26788Redwood Aircraft LLC · Santa Rosa, CABuilt 1978 · S/N AA5A0722 N2678TTekforce LLC · Boca Raton, FLBuilt 1971 · S/N 28-7205078 N2678WLansford Company Inc · Lampasas, TXBuilt 1966 · S/N 999 N26792Mayer David J · Ingleside, ILBuilt 1978 · S/N AA5A0725 N26793Registered aircraftBuilt 1978 · S/N AA5A0727 N26794Seveca Ventures LLC · Arcola, TXBuilt 1978 · S/N AA5A0728

Back to AD 90-04-06 R1