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.

N35700Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1968 · S/N 17256916 N35701Mcha Aviation LLC · Vinita, OKBuilt 1968 · S/N 17256917 N35707Pray Aviation Inc · Augusta, KSBuilt 1968 · S/N 17256921 N3570EBlackbird Aviation Corp · Van Nuys, CAS/N 17271593 N3570SVance Douglas E · Cleveland, GABuilt 1963 · S/N 17250770 N35711Pumphrey Robert B Jr · Saint Paris, OHBuilt 1968 · S/N 17256925 N35712Mw Flying LLC · Sanford, NCBuilt 1968 · S/N 17256926 N3571335713 LLC · Kitty Hawk, NCBuilt 1968 · S/N 17256927 N35714Skyhawk Rising LLC · Manchester, IAFirst renewal noticeS/N 17256928 N35715Kindblade Aeronautics LLC · Casper, WYBuilt 1968 · S/N 17256929 N35716Ward Seth W · Demorest, GABuilt 1968 · S/N 17256930 N35719Jensen Greg D · Omaha, NEBuilt 1968 · S/N 17256932 N3571SGoodman James L · Wray, GABuilt 1963 · S/N 17250771 N35725Kling Jonathan N · Ruther Glen, VABuilt 1968 · S/N 17256936 N35726Jh Aero LLC · Little Rock, ARS/N 17256937 N35728Gone Broke LLC · Fairhope, ALBuilt 1968 · S/N 17256939 N3572QFloyd Richard C · Sutter Creek, CABuilt 1973 · S/N 17261676 N3572SWeidman Paul D · Lebanon, PABuilt 1963 · S/N 17250772 N35730Miner Jay G · Seattle, WABuilt 1968 · S/N 17256940 N35731Registration Pending · Carthage, NCRegistration pendingBuilt 1968 · S/N 17256941 N35735Gaston Brothers Excavating Inc · Seattle, WAS/N 17256943 N35738Plane Life LLC · Wilmington, DEBuilt 1968 · S/N 17256944 N3573QFly Lugu LLC · Westfield, MABuilt 1973 · S/N 17261677 N35741Covelli Scott · Spicewood, TXBuilt 1968 · S/N 17256945 N35744Noland Farms Inc · Blue Mound, ILBuilt 1968 · S/N 17256947 N35746Hoard David L · Germantown, TNBuilt 1968 · S/N 17256948 N35748Price Stanley C · Grapevine, TXBuilt 1968 · S/N 17256950 N35749Pashley John F · Johnstown, NYBuilt 1968 · S/N 17256951 N35751Bas Part Sales LLC · Greeley, COBuilt 1968 · S/N 17256953 N35752Radcliffe Ronald W · Juneau, AKS/N 17256954 N35753Gipson Aviation LLC · Beach City, TXS/N 17256955 N35760Johnson Harry D Jr · Unalakleet, AKS/N 17256957 N35763Woodson Marcus S · Waxahachie, TXBuilt 1968 · S/N 17256958 N3576SGarrison Jerry L · Leavenworth, KSBuilt 1963 · S/N 17250776 N35770Ccb Flyers LLC · Waco, TXBuilt 1968 · S/N 17256959 N35779Syrang Aero Club Inc · Cato, NYFirst renewal noticeBuilt 1968 · S/N 17256961 N3577QSousa Joao P · Prince Frederick, MDBuilt 1973 · S/N 17261678 N3577STorman Kevin B · Umatilla, FLBuilt 1963 · S/N 17250777 N35788Glennon Christopher M · Villa Park, ILBuilt 1968 · S/N 17256962 N3578SHigley Jon · Jerome, IDS/N 17250778 N35790Integrity Aviation Inc · Worthington, MNBuilt 1968 · S/N 17256963 N35792Drerup Henry J · Sebastopol, CAS/N 17256964 N35795N35795 LLC · Fredericksburg, TXBuilt 1968 · S/N 17256965 N35798Big Sky Aviation LLC · Massillon, OHBuilt 1968 · S/N 17256967 N35799Huebner Otto · Bolingbrook, ILS/N 17256968 N357DWFlight Training Aircraft LLC · Wilmington, DEBuilt 2005 · S/N 172S9820 N357ESReeno Aviation LLC · Lewisville, NCBuilt 1997 · S/N 17280007 N357MGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 172S10259 N35801Perkins Richard D · East Otto, NYBuilt 1968 · S/N 17256970 N35802Boeing Employees Flying Association Inc · Ridley Park, PAS/N 17256971

Back to AD 90-06-03 R1