Skip to content

Registered aircraft · 72,010

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-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.

N5643PRed Cardinal Aviation LLC · Chantilly, VABuilt 1959 · S/N 24-713 N5643QGray Eric W · Erie, COBuilt 1965 · S/N 3020 N5643SShedd Christopher · Holly Pond, ALBuilt 1981 · S/N 7352C N5643UExotic Sky LLC · Kalispell, MTBuilt 1969 · S/N 28-26439 N5643ZMcduffie Rodney D · Cullman, ALBuilt 1981 · S/N 8019C N56440Registration Pending · Wilmington, NCRegistration pending, pending cancellationS/N 28R7335437 N56442Registered aircraftBuilt 1982 · S/N 7391C N56445Sturdy Gary · Anacortes, WABuilt 1981 · S/N 7351C N56446Finch Ernest B · Anchorage, AKBuilt 1981 · S/N 7385C N56447Hutton Neil J · Wray, COBuilt 1981 · S/N 7383C N5644MRosenbach Jay A · Chugiak, AKBuilt 1981 · S/N 7380C N5644NTerrane Exploration & Reconnaissance Co LLC · Chandler, AZBuilt 1981 · S/N 7347C N5644QRichey Johnny · Shady Shores, TXBuilt 1965 · S/N 678 N5644UDonaubauer Stefan · Charlotte, NCBuilt 1969 · S/N 28-26441 N5644WHaynon Aircraft Services LLC · Palmer, AKBuilt 1980 · S/N 7350C N5644YGantt William M · Port Orange, FLBuilt 1965 · S/N 27-2758 N564514gaviation LLC · Reading, PABuilt 1973 · S/N 287305595 N56453Richard G Trudeau LLC · Alto, TXBuilt 1973 · S/N 28R-73-35439 N56455Boltman Erik C · Wasilla, AKBuilt 1981 · S/N 7389C N5645DFerenczy Vincent E · Anchorage, AKBuilt 1981 · S/N 7382C N5645FReddoch Mark W Jr · Vidor, TXBuilt 1976 · S/N 28-7790133 N5645PDeines E Jay · Wa Keeney, KSBuilt 1954 · S/N 24-715 N5645URegistration Pending · Huntingdon, TNRegistration pendingBuilt 1969 · S/N 28-26440 N56460Cessna 7870u LLC · Ottumwa, IABuilt 1973 · S/N 28-73-05596 N56461Woody Aaron Michael · Cypress, TXBuilt 1973 · S/N 28R-73-35438 N56462Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1982 · S/N 7409C N56463Freegard Timothy G · Phoenix, AZBuilt 1982 · S/N 7411C N5646MMaule Flight Inc · Moultrie, GAS/N 7390C N5646QGibbons Jack Lee · Alameda, CABuilt 1981 · S/N 7386C N5646UPn4 Aviation Holdings LLC · Bishop, CAS/N 28-26442 N56473Registration Pending · Fort Worth, TXRegistration pendingBuilt 1973 · S/N 287325635 N56474Sampson David M · Clancy, MTBuilt 1973 · S/N 28-7425003 N56475Moertl Harald A · Anchorage, AKBuilt 1982 · S/N 7423C N56477Divelbiss Donald S · Fredericktown, OHBuilt 1973 · S/N 327300063 N5647LFrench Rollie T · Vermillion, SDBuilt 1981 · S/N 7370C N5647PKisken Bill D · Fairbanks, AKBuilt 1982 · S/N 7422C N5647UVargas Orlando O · San Bernardino, CABuilt 1969 · S/N 28-26443 N5647WAuer David A · Springfield, ILBuilt 1962 · S/N 28-804 N56487Burleson Jerry H · Grapevine, TXBuilt 1973 · S/N 28-73-25639 N56488Pensacola Navy Flying Club Inc · Pensacola, FLBuilt 1973 · S/N 28R-73-35444 N5648DGuhr Robert · Stockholm, NJBuilt 1982 · S/N 7418C N5648MBrown Gary R · Eagle River, AKBuilt 1982 · S/N 7415C N5648NAlbert Daniel L · New Athens, ILBuilt 1982 · S/N 7434C N5648QMartin Phil S · Colorado Springs, COBuilt 1965 · S/N 680 N5648WSpinetta Lawrence J · Austin, TXBuilt 1962 · S/N 28-807 N56491Registered aircraftBuilt 1982 · S/N 7399C N56496Ics Air LLC · Saint James, MNBuilt 1973 · S/N 28-7310167 N5649GMaran Properties LLC · Lowell, ARBuilt 1979 · S/N 17273564 N5649MChesnut Lonnie R · Palmer, AKBuilt 1981 · S/N 7395C N5649PTalarek Kai C · Far Hills, NJBuilt 1959 · S/N 24-720

Back to AD 87-10-06 R1