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.

N54956Fluke Dennis M · Sunset, TXBuilt 1981 · S/N 17275090 N5495DSorbi Aviation Inc · El Cajon, CABuilt 1979 · S/N 17272587 N5495KI Fly High LLC · Mesa, AZBuilt 1980 · S/N 17274160 N5495RLee Ernest J Jr · Danielson, CTBuilt 1965 · S/N 17253063 N54960First Eclipse Ltd · Richmond, VAS/N 17275092 N5496HWilson Charles L · Seattle, WABuilt 1975 · S/N 17265466 N5496RFitzgerald Douglas A · Stockton, CABuilt 1965 · S/N 17253065 N54983Jin Jin Aviation LLC · Anchorage, AKBuilt 1981 · S/N 17275098 N5498HGulf Atlantic Airways Inc · Gainesville, FLBuilt 1975 · S/N 17265468 N5498RWilson Dale L · Escalante, UTBuilt 1965 · S/N 17253067 N5498TSale Reported · Lewes, DESale reportedS/N 17251398 N5499RHooper Gordon T · Hiawatha, KSBuilt 1965 · S/N 17253069 N549ASouthern Illinois University · Murphysboro, ILBuilt 2011 · S/N 17281598 N549EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2026 · S/N 172S13547 N549NDSpartan Education LLC · Tulsa, OKBuilt 2010 · S/N 172S11051 N54GCWilson Karlton M · Craigmont, IDBuilt 1959 · S/N 46454 N54JASan Carlos Flight Center Inc · San Carlos, CABuilt 1998 · S/N 17280607 N54JMAviation Institute Of Maintenance · Virginia Beach, VABuilt 1968 · S/N 17257026 N54KHHertenstein Kevin Wayne · Lutz, FLBuilt 1979 · S/N 17272726 N54LULetourneau University · Longview, TXBuilt 2017 · S/N 172S12062 N54PRReimer Lynn C · Sioux Falls, SDBuilt 1972 · S/N 17260943 N54VAFisheer Eric E · Memphis, TNBuilt 1968 · S/N 17257295 N5500GCummings Terence J · Morgan Hill, CABuilt 1971 · S/N 17260300 N5500TOhair Ronald L · Pasco, WABuilt 1964 · S/N 17251400 N5502TMartin William G · Mc Clellandtown, PABuilt 1964 · S/N 17251402 N5503TAivia Aviation LLC · Estes Park, COBuilt 1964 · S/N 17251403 N5504RAerocareers Nfp · Columbia, ILBuilt 1965 · S/N 17253075 N5504TLam Pak To · El Monte, CABuilt 1964 · S/N 17251404 N5505RMerritt Island Flying Club Inc · Merritt Island, FLBuilt 1965 · S/N 17253077 N5505XDuff Trent H · Warrenton, MOBuilt 1964 · S/N 17251188 N5506RAnderson Interests LLC · East Bernard, TXBuilt 1965 · S/N 17253078 N5506TMorgan Ronnie · Keller, TXBuilt 1964 · S/N 17251406 N5507TBlue Feathers Corp · Newark, DEBuilt 1964 · S/N 17251407 N5508TCashmere Origins LLC · Denham Springs, LABuilt 1964 · S/N 17251408 N5509JJet Air Inc · Iowa City, IABuilt 1980 · S/N 17273810 N5509THampsch Jeremy D · Hauser, IDBuilt 1964 · S/N 17251409 N550ERCoco Aircraft Inc · Merritt Island, FLBuilt 2007 · S/N 172S10531 N550LAOscar Tango LLC · Mesa, AZBuilt 2017 · S/N 172S12045 N550NDPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2009 · S/N 172S10992 N5510TStover Aviation LLC · New Braunfels, TXBuilt 1964 · S/N 17251410 N5511RLuv2fly Enterprises Inc · Lewes, DEBuilt 1965 · S/N 17253085 N5511TFreedom Aviation LLC · Mascoutah, ILBuilt 1964 · S/N 17251411 N55121Lifetime Adventures LLC · Bellevue, MIBuilt 1981 · S/N 17275114 N55126Zing Aviation And Marine LLC · New Smyrna Beach, FLFirst renewal noticeBuilt 1981 · S/N 17275116 N5512EMorcom Aviation Services Inc DBA · Everett, WABuilt 1978 · S/N 17271881 N5512RPremier Aircraft Sales LLC · Fort Wayne, INBuilt 1965 · S/N 17253086 N5512TSmith Miles Kent · Las Vegas, NVBuilt 1964 · S/N 17251412 N5513REagle Eye Flight Services LLC · Buffalo, MNS/N 17253087 N5513TMast Jonathan W · Delta, COBuilt 1964 · S/N 17251413 N55144Bell Air LLC · Las Cruces, NMBuilt 1981 · S/N 17275118

Back to AD 90-06-03 R1