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.

N423EWings Over Texas Holdings LLC · Denton, TXBuilt 2014 · S/N 172S11447 N423SCJuliet Charlie Aviation LLC · Oregon City, ORBuilt 2020 · S/N 172S12542 N423SPSierra Papa LLC · Salt Lake City, UTBuilt 2000 · S/N 172S8352 N4240QPerry Nicklette Knight · Port Arthur, TXBuilt 1971 · S/N 17260140 N4241FPankhurst Terrell K · Lauderdale, MSBuilt 1958 · S/N 46141 N4241LAshland Flyers LLC · Bayfield, WIBuilt 1966 · S/N 17254310 N4242CCas LLC Trustee · Ballinrobe Co MayoS/N 172-49187 N4242FChronis Marc D · Pembroke, NHBuilt 1958 · S/N 46142 N4242LHannon Douglas L · Yakima, WABuilt 1966 · S/N 17254311 N4242QRegistered aircraftS/N 17260142 N4243FEagle Glen Veterinary Services Inc · Corona, CAS/N 46143 N4243LNorth Central Marketing Inc · Cranston, RIBuilt 1966 · S/N 17254312 N4244QCox Danny · Peachtree City, GABuilt 1971 · S/N 17260144 N4245LAero Missions Inc · Sylacauga, ALBuilt 1966 · S/N 17254314 N4246QJkg LLC · Murfreesboro, TNBuilt 1971 · S/N 17260146 N4247QSchmitt Michael C · Alva, FLS/N 17260147 N4248FWilcox Ross P · Newark, DEBuilt 1958 · S/N 46148 N4248QPhysics Aviation LLC · Jonesboro, ARBuilt 1971 · S/N 17260148 N4249LKraus Gary L · Holbrook, PABuilt 1966 · S/N 17254318 N424BCPikeside Flying Club Inc · Martinsburg, WVBuilt 1964 · S/N 17252171 N424EChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11448 N424PEUniversity Of Alaska Anchorage · Anchorage, AKBuilt 2017 · S/N 172S12058 N424RESipe Scott W · Georgetown, DES/N 17275599 N424WSkywarrior Flight Training LLC · Pensacola, FLBuilt 1982 · S/N 17275579 N424WMMorrison Jeffrey A · Williamson, GABuilt 1977 · S/N 17269385 N4250LKnight Aire LLC · Simpsonville, SCBuilt 1966 · S/N 17254319 N4250QTice Evan L · Seattle, WABuilt 1971 · S/N 17260150 N4252FLunn James · Winchester, CAS/N 172RG0644 N4252LStephani Timothy M · White Lake, WIBuilt 1966 · S/N 17254321 N4253QFrog Av LLC · Brownstown, INBuilt 1971 · S/N 17260153 N4254FRed Baron LLC · Davis City, IABuilt 1958 · S/N 46154 N4256LStewart Stephanie J · Lakeland, GABuilt 1966 · S/N 17254325 N4256QBurnham Cessna N4256q LLC · Carr, COBuilt 1971 · S/N 17260156 N4259FGuynes Ronald A · Two Rivers, WIBuilt 1958 · S/N 46159 N4259LBrown Lawrence D · Memphis, TNBuilt 1966 · S/N 17254328 N425CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 2001 · S/N 172S8687 N425CRAtp Aircraft 8 LLC · Wilmington, DEBuilt 2014 · S/N 172S11449 N425DBWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17266404 N425DLTotal Flight Aircraft Leasing LLC · Apex, NCBuilt 1979 · S/N 172RG0143 N4260FAyers Frank E · Coulee Dam, WABuilt 1958 · S/N 46160 N4260LTrueman Jeffrey A · Clear, AKBuilt 1966 · S/N 17254329 N4260QLevin Robert G · Roseburg, ORBuilt 1971 · S/N 17260160 N4261FPeri Richard A · Burgess, VABuilt 1958 · S/N 46161 N4261LCochrane Warren H Jr · Carabaset Vly, MEBuilt 1966 · S/N 17254330 N4262FHayton James B · Sedro Woolley, WABuilt 1958 · S/N 46162 N4263LCox Dennis J · Beach City, TXBuilt 1966 · S/N 17254332 N4264LMcguckin Michael C · Mesa, AZBuilt 1966 · S/N 17254333 N4264QAlbrecht Paul J · Mine Hill, NJBuilt 1971 · S/N 17260164 N4265FRedding Steven R · Skiatook, OKBuilt 1958 · S/N 46165 N4265L1515 Aviation LLC · Burleson, TXBuilt 1966 · S/N 17254334

Back to AD 90-06-03 R1