Skip to content

Registered aircraft · 20,683

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-06-03-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-06-03-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-06-03-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-06-03-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-06-03-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-06-03-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.

N64309Sveta Kadirova · Louisville, KYFirst renewal noticeS/N 17265159 N64313Aerial Scouting Solutions LLC · Sioux Center, IABuilt 1975 · S/N 17265163 N64314Registration Pending · New Bern, NCRegistration pendingBuilt 1975 · S/N 17265164 N64317Spernak Airways Inc · Anchorage, AKFirst renewal noticeBuilt 1975 · S/N 17265165 N6431BStecconi Ferraro Denise M · Seattle, WABuilt 1957 · S/N 29631 N6431EGroup 172 LLC · Tucson, AZBuilt 1959 · S/N 46531 N64325Varney Aviation LLC · Bangor, MEBuilt 1982 · S/N 17275545 N64328Compass Aviation Inc · Shelby, NCBuilt 1975 · S/N 17265169 N64329Bvs Aviation LLC · Burns, ORS/N 17265170 N6432BLuebke David M · Canton, SDBuilt 1957 · S/N 29632 N6432VShortridge Randall R · Mesa, AZBuilt 1980 · S/N 172RG0693 N64330Cornelius Beverly B · Merrill, WIBuilt 1975 · S/N 17265171 N6433232 Leasing LLC · Englewood, COBuilt 1975 · S/N 17265172 N64333Sawtooth Aviation LLC · Hovland, MNBuilt 1975 · S/N 17265173 N64334Vrionides Polis G · Collinsville, CTBuilt 1975 · S/N 17265174 N64335Cox Dennis J · Beach City, TXBuilt 1975 · S/N 17265175 N64336Moore Joseph C · Farmers Branch, TXBuilt 1975 · S/N 17265176 N6433EMorgan Peter F · Parma, IDBuilt 1959 · S/N 46533 N64340Spartan Aviation Services LLC · Parkland, FLBuilt 1975 · S/N 17265178 N64344Pensacola Navy Flying Club Inc · Pensacola, FLBuilt 1982 · S/N 17275548 N64345Sundstrom Jeffery V · Fresno, CABuilt 1975 · S/N 17265182 N64350Byrne David D · Essex Fells, NJBuilt 1975 · S/N 17265185 N64355N64355 LLC · Boulder, COS/N 17265187 N64359Brogan Anni T · Anacortes, WABuilt 1975 · S/N 17265190 N6435BCookson Brian E · Cookson, OKS/N 29635 N6435DMarion Military Institute · Marion, ALBuilt 1979 · S/N 17272799 N6435EForte Aviation Parts Inc · Fort Lauderdale, FLBuilt 1959 · S/N 46535 N6435VKirk James B · Lancaster, SCBuilt 1980 · S/N 172RG0696 N64364B&R Aircraft LLC · Wadsworth, OHBuilt 1975 · S/N 17265194 N64367Hardin John M · Terrell, TXBuilt 1975 · S/N 17265196 N6436VJones Gregory D · Pueblo, COS/N 172RG0697 N64377Faircloth William H Jr · Morehead City, NCBuilt 1975 · S/N 17265204 N6437BBrown Michael W · Merced, CABuilt 1956 · S/N 29637 N6437EFremont Flight Service LLC · Fremont, MIBuilt 1959 · S/N 46537 N64383Mission Aviation Training Academy · Arlington, WABuilt 1975 · S/N 17265208 N6438BEllis Matthew P · Broken Arrow, OKBuilt 1957 · S/N 29638 N64390Zarpak Shahab Mike · Bethesda, MDBuilt 1982 · S/N 17275552 N6439EBritt Thomas K · Riverview, FLBuilt 1959 · S/N 46539 N643SPRegistered aircraftBuilt 1998 · S/N 172S8051 N6440DBurns John Michael III · San Mateo, CABuilt 1979 · S/N 17272801 N64411Anderson Gregory S · Reedsville, PABuilt 1975 · S/N 17265209 N64413Hammerton Kenneth R · Olive Branch, MSBuilt 1975 · S/N 17265210 N64414Skyhawk N64414 LLC · Walpole, MABuilt 1975 · S/N 17265211 N64418Mackey Jeffrey S · Dunlap, TNBuilt 1975 · S/N 17265214 N6441BSanpete Air LLC · Spring City, UTBuilt 1957 · S/N 29641 N6441DInter State Aviation Inc · Pullman, WABuilt 1979 · S/N 17272802 N6441FMach III Flying Inc · Platte City, MOBuilt 1979 · S/N 17273224 N64420Pelletier Kevin C · Fort Fairfield, MEBuilt 1975 · S/N 17265216 N64421Celtic Flight LLC · Lewes, DEBuilt 1982 · S/N 17275558 N64423Dsr-Cherokee 180 LLC · Dallas, TXBuilt 1982 · S/N 17275560

Back to AD 90-06-03 R1