Skip to content

Registered aircraft · 54,015

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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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.

N6643GStokes Patricia A · Nenana, AKFirst renewal noticeBuilt 1970 · S/N 15072143 N66440Tenenboym Dennis Alexander · Pinellas Park, FLBuilt 1974 · S/N 15076052 N66449Lindvig Thomas H · Williston, NDBuilt 1978 · S/N 18052944 N6644GLive2flyfl Inc · Wilmington, DEBuilt 1970 · S/N 15072144 N6644MSierra Lima Aviation LLC · Riverton, UTBuilt 1972 · S/N 17260503 N6644TGreenfield Amanda J · Palo, IABuilt 1960 · S/N 15059044 N6644XCamous Daniel E · Miami, FLS/N 21057644 N66452Bedard Michael J Trustee · Madison, ALBuilt 1974 · S/N 15076059 N66453Beaudry Phillip H · Newport, VTBuilt 1974 · S/N 15076060 N66455Soendergaard Carsten · Aguila, AZBuilt 1974 · S/N 15076061 N66459Amelia Reid Aviation LLC · San Jose, CABuilt 1974 · S/N 15076063 N6645TMcelroy James S Jr · Goddard, KSBuilt 1960 · S/N 15059045 N6645XHarrison Joshua C Trustee · Huntington Beach, CABuilt 1960 · S/N 21057645 N66463Sikkema Romke P · Sebring, FLBuilt 1974 · S/N 15076065 N66467Joe Dory Aviation LLC · Star, IDS/N 15076068 N66469Pirtle Sandra Rinehart · Winnsboro, TXBuilt 1974 · S/N 15076070 N6646ERegistration Pending · Elbert, CORegistration pendingBuilt 1959 · S/N 56146 N6646GJenkinson Jeffery J · Montgomery, TXS/N 15072146 N6646HIowa Great Lakes Flyers Inc · Cheyenne, WYBuilt 1975 · S/N 17265523 N6646TGillespie Justin M · Greensboro, NCS/N 15059046 N66471Nelson Travis E · Richland, MTBuilt 1978 · S/N 18052945 N66472Bgmaviate LLC · Fairfax, VABuilt 1974 · S/N 15076072 N66478Mason John M · Gilbert, AZBuilt 1974 · S/N 15076074 N66479Gardner John F · Lyons, NYFirst renewal noticeS/N 15076075 N6648EEverest Builders LLC · Cheyenne, WYS/N 56148 N66494Graham Luke R · Rushville, NEBuilt 1974 · S/N 15076081 N6649AShaw Frank Edward · Chestertown, NYBuilt 1956 · S/N 28749 N664AKWarren John · Homer, AKBuilt 1975 · S/N 17702148 N66501Sanders Robert M · Youngsville, NCBuilt 1974 · S/N 15076084 N66502Dewey Holdings LLC · Florence, ALBuilt 1974 · S/N 15076085 N66506Scott John J · Arcadia, FLBuilt 1974 · S/N 15076086 N66507Gozdowski Matthew D · Sylvania, OHS/N 15076087 N6650TAlumbaugh Bynum E · Jacksonville, FLBuilt 1960 · S/N 15059050 N6650XMccloskey Brett E · Bexley, OHBuilt 1960 · S/N 21057650 N66511Rawaero LLC · Warsaw, MOS/N 15076091 N66516Mangon Aircraft Inc · Petaluma, CABuilt 1974 · S/N 15076094 N66517Sugiond Yudi S · Redlands, CABuilt 1974 · S/N 15076095 N6651ANimmo Jeffrey J · Wilmington, OHBuilt 1956 · S/N 28751 N6651ESutton James Robert · Carson City, NVBuilt 1956 · S/N 56151 N66526Latimer Mary M · Vernon, TXBuilt 1974 · S/N 15076101 N6652MAwesome Aviators LLC · Panora, IABuilt 1975 · S/N 18263791 N66536Ozark Management Inc · Jefferson City, MOBuilt 1974 · S/N 15076105 N66537Woody Oran R · Conroe, TXBuilt 1974 · S/N 15076106 N66539Vargas Serrano Marco Leandro · Roosevelt, UTS/N 15076108 N6653AAntanovich Matthew J · Bentleyville, PABuilt 1956 · S/N 28753 N6653BWilson Gale E · Lewiston, IDS/N 21062806 N6653FKerns Christopher R · Chillicothe, OHBuilt 1966 · S/N 15063253 N6653TRandall Jeffrey A · Abilene, TXBuilt 1960 · S/N 15059053 N66540Georges Aviation Services Inc · Honolulu, HIS/N 17275990 N66541Hardison Samuel H Jr · Mountain View, ARBuilt 1974 · S/N 15076110

Back to AD 87-20-03 R2