Skip to content

Registered aircraft · 20,680

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.

N122PWKal Aero Flight Instruction LLC · Mattawan, MIBuilt 1966 · S/N 17255433 N122RPWerner Bryce R · Blue Earth, MNBuilt 1966 · S/N 17254543 N122SSGrain Belt Aviation LLC · Malcolm, NEBuilt 1975 · S/N 17264842 N122VKWings Over Texas Holdings LLC · Denton, TXBuilt 2005 · S/N 172S9856 N122WEOhio State University · Columbus, OHBuilt 2019 · S/N 172S12396 N1230GFlight Training Aircraft LLC · Wilmington, DEBuilt 2005 · S/N 172S9838 N1232GDirty Side Down Aviation LLC · Georgetown, TXBuilt 2002 · S/N 172S9095 N1232UOrganization Of Black Aerospace Professionals Inc · Westchester, ILS/N 17266928 N12330Liller Kenneth F · New Port Richey, FLBuilt 1973 · S/N 17261932 N12331N Conti Inc · Boyertown, PABuilt 1973 · S/N 17261933 N12335Truscott Jon M · Sunfield, MIBuilt 1973 · S/N 17261935 N12336Qualitair LLC Trustee · MichelstadtBuilt 1973 · S/N 17261936 N12339Howard Ronald W · Okeechobee, FLBuilt 1973 · S/N 17261937 N1233UMagnum Air LLC · Camp Hill, PABuilt 1976 · S/N 17266929 N12341Merl Robert B · Los Alamos, NMBuilt 1973 · S/N 17261938 N12342Simpson Elden G · Prineville, ORBuilt 1973 · S/N 17261939 N12343Albany Aviation Ny LLC · Nassau, NYBuilt 1973 · S/N 17261940 N12346Baidenmann Maralin Frances · Bend, ORBuilt 1973 · S/N 17261941 N1234SGale Jeremy C · Clear Lake, WIS/N 17254335 N1235ESale Reported · Lewes, DESale reportedS/N 172S9847 N12360Wings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17261947 N12365Singh Jaganpreet · Bakersfield, CABuilt 1973 · S/N 17261950 N12366Zimmerman Michael P · Verona, WIBuilt 1973 · S/N 17261951 N1236UKosmoski Matthew J · Katy, TXBuilt 1976 · S/N 17266931 N12375Bauer Kathleen S · Harrison City, PABuilt 1973 · S/N 17261954 N12376Lockwood Connor A · Anchorage, AKS/N 17261955 N12379Kolar Ken DBA · Brazoria, TXBuilt 1973 · S/N 17261957 N1237UStaehling Jonathan J · Woodstock, ILBuilt 1976 · S/N 17266932 N12382Blue Sky Pilots Inc DBA · Salem, ORBuilt 1973 · S/N 17261958 N12386Fly White Cloud LLC · Lake Havasu City, AZS/N 172S9857 N12387Bayramoglu Ulug S · Carrollton, TXS/N 17261961 N12388Autry Lonnie E · San Jose, CABuilt 1973 · S/N 17261962 N12390Lowcountry Aviation Company Brokerage LLC · Walterboro, SCBuilt 1973 · S/N 17261963 N12391Lowe Ralph D · Magnolia Springs, ALBuilt 1973 · S/N 17261964 N12394Hayek David · Bryan, TXBuilt 1973 · S/N 17261967 N12395Consolidated Aviation Services LLC · Seymour, TNBuilt 1973 · S/N 17261968 N12398Cianfichi Jamie J · Moscow, PABuilt 1973 · S/N 17261971 N123ACAerocareers Nfp · Columbia, ILBuilt 1962 · S/N 17249624 N123CBC C Flying Club · Seattle, WABuilt 1973 · S/N 17262283 N123CLPcs Air LLC · Middletown, PABuilt 1972 · S/N 17261064 N123CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 172S13483 N123FCCurtis James · Abilene, KSBuilt 1970 · S/N 17259182 N123GG150th Aero Flying Club · Morristown, NJBuilt 2004 · S/N 172S9600 N123GJAftcloud Inc · Ontario, CABuilt 1978 · S/N 17270706 N123HAR & R Aviation Services LLC · Festus, MOBuilt 1972 · S/N 17261048 N123KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1977 · S/N 17268627 N123LGDaniels Garry E · Humboldt, KSBuilt 1974 · S/N 17263957 N123PBTextron Aviation Inc · Wichita, KSS/N 172S13648 N123PFJet Air Inc · Iowa City, IABuilt 1999 · S/N 172S8086 N123PYDotson Daniel · Holly Springs, MSBuilt 1966 · S/N 17254641

Back to AD 90-06-03 R1