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.

N2838UCag Farms Inc · Angier, NCS/N 17250438 N2839UEttelson Michael J · New Hampton, NHBuilt 1963 · S/N 17250439 N283MEN283me LLC · Manassas, VABuilt 2000 · S/N 172S8541 N283PEDolphin Leasing LLC · Daytona Beach, FLBuilt 2009 · S/N 172S10897 N2840UDejong Robert W · Austin, TXBuilt 1963 · S/N 17250440 N2841LJustison David · Hillsboro, ILS/N 17256041 N2841QWight John I · Anchorage, AKBuilt 1971 · S/N 17259841 N2842ELyon Aviation Inc · Pittsfield, MABuilt 1978 · S/N 17271342 N2842LBravo Aviation LLC · Rexburg, IDBuilt 1967 · S/N 17256042 N2842QLaning Roland · Monument, COBuilt 1971 · S/N 17259842 N2842UDeshaies Robert · Cumberland, RIBuilt 1963 · S/N 17250442 N2843UFlite Five Inc · Kiowa, KSBuilt 1963 · S/N 17250443 N2844QReigle Aviation · Palmyra, PABuilt 1971 · S/N 17259844 N2845LShenk Ronald W · Palmetto, GABuilt 1967 · S/N 17256045 N2846QStafford Richard J · Bayport, NYBuilt 1971 · S/N 17259846 N2847LGervase Russell · Farmington, NMBuilt 1967 · S/N 17256047 N2847QDobbelaere Craig M · Oakwood, OHBuilt 1972 · S/N 17259847 N2848QFirst Eclipse Ltd · Richmond, VABuilt 1971 · S/N 17259848 N2849QSilver Ranch Airpark Inc · Jaffrey, NHBuilt 1971 · S/N 17259849 N284LPSo Cal Leasing LLC · El Cajon, CABuilt 2002 · S/N 172S9284 N284MEPatriot Leasing LLC · Franklin, TNBuilt 2000 · S/N 172S8542 N284RARekast Flying Services Inc · Englewood, FLBuilt 1984 · S/N 17276151 N2850LBergmann Robert A · Lake Placid, FLBuilt 1967 · S/N 17256050 N2851LMorristown Flying Service Inc · Talbott, TNBuilt 1967 · S/N 17256051 N2852LHardin County Aviation LLC · Kountze, TXBuilt 1967 · S/N 17256052 N2852QMillard Randy W · Auburn, CABuilt 1971 · S/N 17259852 N2852UWatten Sig V · Rhinelander, WIBuilt 1963 · S/N 17250452 N2853QShelton Stefon E · Oakland, CABuilt 1971 · S/N 17259853 N2854UGerbig Robert A · Gleason, WIBuilt 1963 · S/N 17250454 N2855LParis Flight Training LLC · Powderly, TXBuilt 1967 · S/N 17256055 N2856UNguyen Trinh Kieu Thi · Jacksonville, FLBuilt 1963 · S/N 17250456 N2857LKeller Thomas Joe · Chattanooga, OKBuilt 1967 · S/N 17256057 N2857QM3 Aviation Florida LLC · Fort Pierce, FLBuilt 1971 · S/N 17259857 N2857UAuck Allyn L · Fort Mohave, AZBuilt 1963 · S/N 17250457 N2858LAgile Systems LLC · Simpsonville, SCS/N 17256058 N2858QKelley Aircraft LLC · Weyers Cave, VABuilt 1971 · S/N 17259858 N2858UGelfius Glenn E · Dahlgren, ILBuilt 1963 · S/N 17250458 N2859LWheadon William J · Napa, CABuilt 1967 · S/N 17256059 N2859QSullivan Mark F · Cocoa Beach, FLBuilt 1971 · S/N 17259859 N285JSFlytruckeetahoe Inc · Truckee, CABuilt 1976 · S/N 17268035 N285PEBravo Leasing LLC · Daytona Beach, FLBuilt 2009 · S/N 172S10888 N285THAtp Aircraft 2 LLC · Wilmington, DEBuilt 2018 · S/N 172S12130 N285VNElizabeth City State University · Elizabeth City, NCBuilt 2019 · S/N 172S12414 N2860QLawton Metropolitan Area Airport Authority · Lawton, OKBuilt 1971 · S/N 17259860 N2861QBlackmon Robert · San Antonio, TXBuilt 1971 · S/N 17259861 N2862UWallace Jon W · Ozark, ARBuilt 1963 · S/N 17250462 N2863EWetherley Aviation LLC · Boise, IDBuilt 1978 · S/N 17271352 N2863QSalsbery Randall E · Sharpsville, INBuilt 1971 · S/N 17259863 N2864LTakle Management LLC · Bethany, OKS/N 17256064 N2864QEaglet Flight Operations Lp · Fort Worth, TXBuilt 1971 · S/N 17259864

Back to AD 90-06-03 R1