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.

N411ESAttitude Aviation Inc · Livermore, CABuilt 1997 · S/N 17280223 N411RFFoothill Aircraft Sales & Service Inc · Upland, CAS/N 17252216 N411SSDalmolin Russell Scott · Globe, AZBuilt 1973 · S/N 17261603 N4121FHarrold Bruce E · Greybull, WYBuilt 1958 · S/N 46021 N4124FNelson David R Co-Trustee · New Richmond, WIBuilt 1958 · S/N 46024 N4125FSale Reported · Addison, TXSale reportedBuilt 1958 · S/N 46025 N4125LEvans Samuel F · Selma, ALS/N 17254194 N4126FRider Terry · Corinth, MSBuilt 1958 · S/N 46026 N4126LBritton Jeff J · Forest Falls, CABuilt 1966 · S/N 17254195 N4127FDavolt John E · Independence, KSFirst renewal noticeBuilt 1958 · S/N 46027 N4127LHoldt Farms Inc · Elgin, NEBuilt 1966 · S/N 17254196 N4128FSkidmore Arnold D · Williamsburg, OHBuilt 1958 · S/N 46028 N4129LIrwin Kristin L · Emporia, KSS/N 17254198 N412FBLunken Flight Training Center LLC · Cincinnati, OHBuilt 2017 · S/N 172S12043 N412FRAtp Aircraft 8 LLC · Wilmington, DEBuilt 2014 · S/N 172S11443 N412SPChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 172S8322 N412WMBroadwell Group Inc · Alpharetta, GABuilt 2012 · S/N 172S11175 N41306Bruns Darcy · Sandia, TXBuilt 1969 · S/N 17258310 N4132FBaldwin Vivian E · Owasso, OKBuilt 1958 · S/N 46032 N4134FGaffney Mark M · Lincoln, NEBuilt 1958 · S/N 46034 N4134LMountain View Aviation Inc · Cedar Bluff, VABuilt 1966 · S/N 17254203 N4135LHudson Kimmine · Erie, COBuilt 1966 · S/N 17254204 N4136LDickerson Richard L · Fort Worth, TXBuilt 1966 · S/N 17254205 N413AAAmerican Aviation Inc · Brooksville, FLBuilt 2000 · S/N 172S8413 N413CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13239 N413CDBecktold Stanley T · Richland, ORBuilt 1962 · S/N 17249689 N413EBG&M Aircraft Inc · Wheat Ridge, COBuilt 1979 · S/N 172RG0113 N413EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12640 N413ESAbove And Beyond Aviation LLC · Austin, TXBuilt 1997 · S/N 17280218 N413MASterling Flight Training LLC · Jacksonville, FLBuilt 1976 · S/N 17267164 N4141LPeder Richard A · Sequim, WABuilt 1966 · S/N 17254210 N4142LSegura Michelle Marie · Dallas, TXBuilt 1966 · S/N 17254211 N4143FSteier Tim A · Salome, AZBuilt 1958 · S/N 46043 N4144FKoch Gerald P · Mount Vernon, SDBuilt 1958 · S/N 46044 N4146FGompert Andrew B · Burwell, NEBuilt 1958 · S/N 46046 N4147FSwan Steve · Jackson, WYBuilt 1958 · S/N 46047 N4148FBorders Jimmie L · Tompkinsville, KYBuilt 1958 · S/N 46048 N4149FCarruth Peter J · Benson, MNS/N 46049 N4149LRegistration Pending · Bryan, OHRegistration pendingS/N 17254218 N414ERRegistration Pending · Wilmington, DERegistration pendingBuilt 2017 · S/N 172S12026 N414TBTextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2026 · S/N 172S13494 N4150FRegistration Pending · Clinton Township, MIRegistration pendingS/N 46050 N4150LBlankenship Daniel S · Paso Robles, CABuilt 1966 · S/N 17254219 N4151LPardun Phillip R · Mason City, IABuilt 1966 · S/N 17254220 N4152FGaertner Kim L · Oconto, WIBuilt 1958 · S/N 46052 N4152LLambert Robert · Paoli, INBuilt 1966 · S/N 17254221 N4153FChaffee Craig O · Le Raysville, PABuilt 1958 · S/N 46053 N4156FPintar Robert · Spokane, WAS/N 46056 N4156LZimmer Marc R · Moses Lake, WABuilt 1966 · S/N 17254225 N4157FBeasley John V III · Amarillo, TXS/N 46057

Back to AD 90-06-03 R1