Skip to content

Registered aircraft · 18,497

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:86-13-04-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3') 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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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:86-13-04-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
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.

N47589Radke John A · Cedar Falls, IABuilt 1977 · S/N 28R-7703404 N4758KRuvo Scott J · Augusta, NJBuilt 1979 · S/N P21000289 N4759ERatcliff Stephen B · Anchorage, AKBuilt 1979 · S/N 18503865 N4759MTempel Warren K · Longmont, COBuilt 1978 · S/N E-1300 N4759QPease Robert J · Anchorage, AKBuilt 1967 · S/N 185-1220 N475CDBird 33 LLC · Cody, WYBuilt 2005 · S/N 1574 N475ECGarcia Paola Olivares · El Paso, TXBuilt 1979 · S/N E-1446 N475JGwaltney Air Inc · Alexander City, ALBuilt 1994 · S/N E-2883 N475JMSmm Aviation LLC · Destin, FLBuilt 2001 · S/N E-3368 N475RBN475rb LLC · Lexington, KYBuilt 1997 · S/N 29-0121 N475RCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1978 · S/N 4040223 N475TTTubb Jeffrey Scott · Farmington, NMBuilt 2023 · S/N E-4150 N4761AAmarel Robert E Jr · Yuba City, CABuilt 1983 · S/N P21000821 N4761CForbis Aviation LLC · Calera, OKBuilt 1979 · S/N 21063617 N4761KLyman Leslie F · Walnut Grove, CABuilt 1979 · S/N P21000292 N4761QMichaelson Lawrence · Big Lake, AKBuilt 1967 · S/N 185-1226 N4762EFly185 LLC · Estes Park, COBuilt 1979 · S/N 18503868 N4763GGamma Transport Solutions Inc · Carrollton, TXFirst renewal noticeBuilt 1977 · S/N 414-0938 N47645Arizona Type Ratings LLC · Sedona, AZBuilt 1980 · S/N 340A0992 N4764BPratt Sean · Hampton, NHBuilt 1977 · S/N 18503371 N4764MSpooner James Leonard · Carlisle, PAS/N CE-782 N4764QShapiro David · Homer, AKBuilt 1967 · S/N 185-1230 N4764YOk3wire Properties LLC · Pensacola, FLBuilt 1973 · S/N D-9418 N4765GAircraft Charter And Leasing LLC · El Cerrito, CABuilt 1977 · S/N 414-0940 N4765QDigger Dougs Crop Dusting Services Inc · Salem, WIBuilt 1976 · S/N 18802513T N4766EWillard Raymond C · Wasilla, AKBuilt 1979 · S/N 18503872 N4766MFx5 Construction & Excavation Inc · Decatur, TXBuilt 1978 · S/N E-1259 N4767UDeckload Aviation LLC · Kodiak, AKBuilt 1979 · S/N U20605091 N4768FZankiz Jose Carlos · Naples, FLS/N P206-0368 N4768KJohnson Durwood · Beaumont, TXS/N P21000299 N4768PBoone Patrick J · San Antonio, TXBuilt 1978 · S/N P21000101 N4769KSpirit 210 LLC · Missoula, MTBuilt 1979 · S/N P21000300 N476EWWny Air Inc · Dover, DEBuilt 1996 · S/N TH-1797 N476LSHoffman Anthony J Trustee · Hillsboro, ORBuilt 1976 · S/N U20603283 N476WBurkhard Daniel A · Vero Beach, FLBuilt 1979 · S/N D-10286 N476WGTrow Michael P · Seattle, WABuilt 2002 · S/N 0389 N4770KPaulk Charles Jr · Naples, FLBuilt 1979 · S/N P21000301 N4771KAshby Kenny · Mead, COBuilt 1979 · S/N P21000302 N4772ADodson International Parts Inc · Rantoul, KSS/N 414A0095 N4772QHodgson John P · Atlanta, GABuilt 1967 · S/N 185-1239 N4773CDickert Daniel · Cross City, FLBuilt 1979 · S/N 21063621 N4773KReason Farms · Yuba City, CABuilt 1979 · S/N P21000304 N4773PCoeur De Air LLC · Mcminnville, ORBuilt 1978 · S/N P21000102 N4773UFins Fur & Feathers Flying LLC · King Salmon, AKBuilt 1979 · S/N U20605094 N4774KWingfield John J · Parker, TXBuilt 1979 · S/N P21000305 N4775KBas Part Sales LLC · Greeley, COBuilt 1979 · S/N P21000306 N4775MJ And J Consulting LLC · South Jamesport, NYBuilt 1978 · S/N D-10131 N4775QShelk John Brian · Bend, ORBuilt 1967 · S/N 185-1242 N4776UHabberstad John L · Rathdrum, IDBuilt 1979 · S/N U20605096 N4777UAdair Aviation LLC · Broken Arrow, OKBuilt 1983 · S/N 21064814

Back to AD 86-13-04 R3