Skip to content

Registered aircraft · 20,687

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.

N7800TNorth Texas Aeronautics LLC · Burleson, TXBuilt 1960 · S/N 47400 N7800URipplinger Max · Santa Clara, UTBuilt 1964 · S/N 17251800 N7801XHuckins Randall A · Goddard, KSS/N 17248301 N78027Cramlet Kirk T · Woodlake, CABuilt 1968 · S/N 17257467 N7802XDykstra Wayne A · Pipestone, MNBuilt 1961 · S/N 17248302 N7803GTomlin Jonathan S · Georgetown, OHS/N 17259503 N7803UBishop John D · Phoenix, AZBuilt 1964 · S/N 17251803 N7804GWells Adam · New Lexington, OHBuilt 1970 · S/N 17259504 N7805GArgabright John · Waterford, OHBuilt 1970 · S/N 17259505 N7805TSanford William M · Olalla, WABuilt 1960 · S/N 47405 N78066Orlandi Properties LLC · Blairstown, NJBuilt 1968 · S/N 17257470 N7806GAircraft Management Services Inc · Milton, FLBuilt 1970 · S/N 17259506 N78076Clinton Aeroclub · Clinton, IABuilt 1968 · S/N 17257472 N78078International Air Services Inc Trustee · Carson City, NVBuilt 1968 · S/N 17257473 N7807GLake Of The Woods Aviation LLC · Baudette, MNS/N 17259507 N7807XFarwell Joseph W · Holmen, WIBuilt 1961 · S/N 17248307 N78086Drake Ronald N · Helena, MTBuilt 1968 · S/N 17257475 N7808TMckay H Samuel · Barnwell, SCBuilt 1960 · S/N 47408 N78095Leuer James A · Encinitas, CABuilt 1968 · S/N 17257480 N7809GHodge Aviation LLC · Monroe, LABuilt 1970 · S/N 17259509 N7809UHigh Planes Aviation LLC · Waseca, MNFirst renewal noticeBuilt 1964 · S/N 17251809 N780BGMaw Enterprises USA LLC · Hudson, FLBuilt 1980 · S/N 17274382 N780BWBridgewater State University · North Dartmouth, MABuilt 2000 · S/N 172S8600 N780EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2026 · S/N 172S13569 N780JAPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2007 · S/N 172S10476 N7810URasch Hellmut G · Tomball, TXS/N 17251810 N7810XCoats Benjamin F II · Ducktown, TNBuilt 1960 · S/N 17248310 N78112Botnick Eric L · Luling, LABuilt 1968 · S/N 17257486 N7811THoke Cylus G · Culver, ORBuilt 1960 · S/N 47411 N7811XMach 3 LLC · Enid, OKBuilt 1961 · S/N 17248311 N78123Rrr3 LLC · Midway, FLS/N 17257490 N78124Barrow James L · Elizabethtown, KYBuilt 1968 · S/N 17257491 N78126Orme Jason R · Red Oak, IABuilt 1968 · S/N 17257492 N7812TCurzon John R · Brookings, ORS/N 47412 N7812UPs Aviation Inc · Granada, MNS/N 17251812 N78130Garoutte Kirk E · Anchorage, AKBuilt 1968 · S/N 17257493 N78139Van Straten Patrick F · Shiocton, WIBuilt 1968 · S/N 17257497 N78142Partyka Kenneth M · Circle Pines, MNBuilt 1968 · S/N 17257499 N78144Kyzer Aviation Holdings LLC · Fort Mill, SCS/N 17257500 N7814XOsterhouse Timothy D · Kalamazoo, MIBuilt 1961 · S/N 17248314 N78158Hill Donald J · Godfrey, ILBuilt 1968 · S/N 17257505 N7815DAviation Training LLC · Wilmington, DEBuilt 2006 · S/N 172S10310 N7815GNextgen Flight Academy Inc · Riverside, CABuilt 1970 · S/N 17259515 N7815XHearn Brian Franklin Trustee · Carrabelle, FLBuilt 1961 · S/N 17248315 N78174Spencer Aviation Inc · Delaware, OHBuilt 1968 · S/N 17257510 N78179Horgan Robert V Jr · Wolfeboro, NHS/N 17257513 N7817GBarnhard James L · Washington, DCBuilt 1970 · S/N 17259517 N78180Gatewood Doris E · Stokesdale, NCBuilt 1968 · S/N 17257514 N78182Ajayi Samuel O · Jacksonville, ARS/N 17257515 N78183Smolik Vincent C · Ponder, TXBuilt 1968 · S/N 17257516

Back to AD 90-06-03 R1