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.

N8372XN8372x LLC · Chelan, WABuilt 1961 · S/N 17248872 N8373BSkyview Aviation LLC · Tracy, CABuilt 1957 · S/N 36173 N8373LFaulkner Jeannine P · Bethel, AKFirst renewal noticeBuilt 1968 · S/N 17256573 N8373UKramer Mark S · Branchburg, NJBuilt 1964 · S/N 17252273 N8373XPenrose Cory · Reno, NVBuilt 1941 · S/N 17248873 N8374BGardner Gilbert W · Hartford, KSBuilt 1957 · S/N 36174 N8374LGeneral Aviation LLC · Henderson, NVBuilt 1968 · S/N 17256574 N8375BRutan James · Palmer, AKS/N 36175 N8375TChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 172S12410 N8375XDugan Ronald C · Rogers City, MIBuilt 1961 · S/N 17248875 N8376BBilton Aircraft Management Inc · Umatilla, FLBuilt 1957 · S/N 36176 N8376XDraeger Joshua D · De Leon, TXBuilt 1961 · S/N 17248876 N8377BLittle Eagle Valley LLC · Dover, DEBuilt 1957 · S/N 36177 N8377HRhodes Kent A · Seattle, WABuilt 1956 · S/N 29426 N8378LLett Brian R · Eden Prairie, MNBuilt 1968 · S/N 17256578 N8379LSan Fernando Aviation LLC · Van Nuys, CAS/N 17256579 N837CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11585 N837KSKansas State University · Salina, KSBuilt 2019 · S/N 172S12307 N837LAVolar Xi LLC · Edmond, OKBuilt 2011 · S/N 172S11074 N837SPIsrani Vijay · Cupertino, CABuilt 2001 · S/N 172S8727 N8380BShull Thomas A · Copper Center, AKBuilt 1957 · S/N 36180 N8380UTrp Enterprises Inc · Mocksville, NCBuilt 1965 · S/N 17252280 N8381BRaymond Kyle Inc · Eagle, COS/N 36181 N8381LShielded Holdings LLC - Series Av 12 · Katy, TXBuilt 1968 · S/N 17256581 N8381UFuryious Aviation LLC · Bossier City, LABuilt 1964 · S/N 17252281 N8382BDevore Plane Affects Lp · Independence, KSS/N 36182 N8382LMedina Solla Edwin O · Trujillo Alto, PRBuilt 1968 · S/N 17256582 N8383BSpears Franklin L · Lebanon, KYBuilt 1957 · S/N 36183 N8383UBuzby Justin T · Wasilla, AKBuilt 1964 · S/N 17252283 N8384XVehrs Roger K · Roseburg, ORBuilt 1961 · S/N 17248884 N8385BTkn Holdings LLC · Pima, AZBuilt 1957 · S/N 36185 N8385LKrebs Lisa Christine · Homer, AKBuilt 1968 · S/N 17256585 N8385UClow Streeter M · Mansfield, OHFirst renewal noticeBuilt 1964 · S/N 17252285 N8386LAdams Haidyn · Pentwater, MIS/N 17256586 N8386XSchool Board Of Leon County Florida · Tallahassee, FLBuilt 1961 · S/N 17248886 N8387LSerra Christopher R · Snellville, GABuilt 1968 · S/N 17256587 N8387URegistered aircraftBuilt 1964 · S/N 17252287 N8388BTouch And Go Inc · Center, COBuilt 1957 · S/N 36188 N8389LJkg LLC · Murfreesboro, TNBuilt 1968 · S/N 17256589 N838EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S12961 N838KSKansas State University · Salina, KSBuilt 2019 · S/N 172S12308 N838MPWhitney Stephen · Fort Myers, FLS/N 17258274 N838SPEdb Air Inc · Wilsonville, ORBuilt 2001 · S/N 172S8736 N8390LBliss Marketing Communications Inc · Phoenix, AZBuilt 1968 · S/N 17256590 N8390XMoore Laura D · Sacramento, CABuilt 1961 · S/N 17248890 N8391XAmerican Aviation Inc · North Wilkesboro, NCBuilt 1961 · S/N 17248891 N8392BWeber Thomas P · North Bend, WABuilt 1957 · S/N 36192 N8392URegistered aircraftBuilt 1964 · S/N 17252292 N8393BSingh Gurdev · Cathedral City, CABuilt 1957 · S/N 36193 N8393LJohns Ryan · Sabillasville, MDBuilt 1968 · S/N 17256593

Back to AD 90-06-03 R1