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.

N4218QSavant John D · Kinder, LAS/N 17260118 N4219FHazellief Quillie J Jr · Okeechobee, FLBuilt 1958 · S/N 46119 N4219QAudrain Flying Club Inc · Mexico, MOS/N 17260119 N421CVRed-Tailed Hawks Aviation Academy Inc · Mukilteo, WABuilt 1979 · S/N 17272437 N421ERCc Aviation Inc · Tracy, CABuilt 2004 · S/N 172S9679 N421FPJustus Christopher S · Corona, CABuilt 1998 · S/N 17280638 N421RWPac1 LLC · Clinton, IABuilt 2004 · S/N 172S9593 N4220FLeubner Karl T · Marietta, NYS/N 46120 N4220LDelordzia Mark · Columbia, NJBuilt 1966 · S/N 17254289 N42212Caves Xxi Properties LLC · Virginia Beach, VABuilt 1974 · S/N 17264163 N4221LSchram Ted K · Mukwonago, WIBuilt 1966 · S/N 17254290 N4221QRegistered aircraftBuilt 1971 · S/N 17260121 N4222FBelford Zackery U · Elizabethtown, ILBuilt 1958 · S/N 46122 N4222LRtd Aviation LLC · Hillsborough, NJS/N 17254291 N4222QBearlodge Spray Foam & Coatings LLC · Sundance, WYS/N 17260122 N4223LWolinski David T · Algonquin, ILBuilt 1966 · S/N 17254292 N4224QPressley Aviation LLC · New London, NCBuilt 1971 · S/N 17260124 N4225L100straight LLC · San Angelo, TXBuilt 1966 · S/N 17254294 N4225QBraddock Karrol L · Globe, AZBuilt 1971 · S/N 17260125 N4226LMcpherson Charles C III · Delhi, LABuilt 1966 · S/N 17254295 N4227LJohnson Wayne · Broken Arrow, OKBuilt 1966 · S/N 17254296 N4227QSchoenfeld Paul E · Midvale, UTBuilt 1971 · S/N 17260127 N4228FLangland Llewellyn D · Sarona, WIBuilt 1958 · S/N 46128 N4228QWings Over Texas Holdings LLC · Denton, TXBuilt 1971 · S/N 17260128 N42292Breier Michael D · Pasco, WABuilt 1974 · S/N 17264168 N4229FRoss Sam M · Pioneer, LABuilt 1958 · S/N 46129 N422BPreston Richard K Trustee · Albuquerque, NMS/N 17268342 N422CBHeavy Metal Air LLC · Farmingdale, NYBuilt 2005 · S/N 172S10011 N422EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2017 · S/N 172S12022 N422HABrightwater Enterprises LLC · Lakeway, TXBuilt 2005 · S/N 172S9830 N422LSSkyknight LLC · Greeneville, TNBuilt 2011 · S/N 172S11117 N422RGGerwig Ellen W · Anderson, SCBuilt 1966 · S/N 17255579 N4230FBiffle Sam E · Midland, TXBuilt 1958 · S/N 46130 N4230QAir Castles LLC · Ozark, ALBuilt 1971 · S/N 17260130 N4231FYancey Emron A · Sterling, AKS/N 46131 N4231LSeaplanes R Fun Inc · Moneta, VABuilt 1966 · S/N 17254300 N4231TInternational Air Services Inc Trustee · Carson City, NVS/N 172S12370 N4233FSilverman James R · Superior, MTS/N 46133 N4233LTulsa Technology Center School District No 18 · Tulsa, OKBuilt 1966 · S/N 17254302 N4233QWoods John B · Anchorage, AKBuilt 1971 · S/N 17260133 N4234QFarr Everett L III · Bensalem, PABuilt 1971 · S/N 17260134 N4235FCastle Nial K III · Bonner Springs, KSBuilt 1958 · S/N 46135 N4235LReiter Trevor D · Minot, NDBuilt 1966 · S/N 17254304 N42361Lima 001 LLC · Muscatine, IABuilt 1974 · S/N 17264171 N4236LPierce Russell A · San Antonio, TXBuilt 1966 · S/N 17254305 N4237FScherr Steven J · Mandan, NDBuilt 1958 · S/N 46137 N4238QFisch Markus J · Rock Falls, ILBuilt 1971 · S/N 17260138 N4239FDitmars William R · Redding, CABuilt 1958 · S/N 46139 N4239QElizabeth City State University · Elizabeth City, NCS/N 17260139 N423CAAerochatt LLC · Cleveland, TNBuilt 2015 · S/N 172S11612

Back to AD 90-06-03 R1