Skip to content

Registered aircraft · 5,075

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:84-19-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:84-19-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:84-19-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:84-19-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:84-19-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:84-19-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.

N345DPBack Country Hacks LLC · Olalla, WABuilt 2001 · S/N T20608269 N345MMMarciaran LLC · Dover, DEBuilt 1990 · S/N 4622112 N345RPMcdole Consulting LLC · Southern Shores, NCBuilt 1990 · S/N 4622096 N345SEPlane Fun Inc Tr Trustee · Snellville, GABuilt 2004 · S/N 3257345 N3469246dk LLC · Ramona, CABuilt 2004 · S/N T18208248 N347CBMishock Kevin A · Melbourne, FLBuilt 1976 · S/N 32R-7780002 N347DWSnoopy Air LLC · Branch, LABuilt 1996 · S/N 4636059 N348PSTim Moyer Management LLC · Whitefish, MTBuilt 2005 · S/N 27-0348 N3495QBoswell Alan · Chrisney, INBuilt 1967 · S/N 320E-0095 N349CHAce Flight Center Inc · St Thomas, VIBuilt 1968 · S/N 27-3949 N349MAMa Sammy · S San Fran, CABuilt 2004 · S/N 3257349 N34FMCordero Jose Robert · El Paso, TXFirst renewal noticeBuilt 1998 · S/N 27-0241 N34MALk Air Inc · Arlington, WAS/N 32-40219 N34WM70 North LLC · Anchorage, AKBuilt 1973 · S/N 31-7305125 N34XTGwk Aviation LLC · Fort Smith, ARBuilt 2005 · S/N 3255034 N3502JAv Solutions Inc · Flint, MIS/N T18208058 N3506YCascade Commodities LLC · Saint Paul, MNBuilt 2001 · S/N T20608311 N350ARAbode Construction Inc · Marion, IABuilt 1990 · S/N 4622109 N350CAMajors Donald G Jr · Cave Creek, AZBuilt 2002 · S/N 3257279 N350GBCarto-Flight · Willoughby, OHBuilt 1980 · S/N 31-8052136 N3516AAirplane 2 LLC · Sedona, AZBuilt 1979 · S/N 31-7952106 N35187Collins Daniel W Jr · Alvarado, TXS/N 31-7912056 N351WTFree Bird Air LLC · Raymond, NEBuilt 1996 · S/N 4636071 N3520XGv Air Inc · Medford, ORBuilt 1979 · S/N 31-7912067 N3523DQuick Gas Aviation LLC · Thomasville, GABuilt 1979 · S/N 31-7952112 N3523YL A B Flying Service Inc · Renton, WAS/N 31-7952115 N35261Walrath Aviation LLC · Tacoma, WABuilt 2001 · S/N T18208013 N35269Marlin Aviation Inc · West Palm Beach, FLBuilt 1979 · S/N 31-7952136 N3527XSzmagala Taras G Jr · Bentleyville, OHBuilt 1975 · S/N 32-7540163 N3529AMajestic Enterprises Ltd · Wilmington, DEBuilt 1979 · S/N 31-7952152 N3529WMission Flight · El Monte, CABuilt 1979 · S/N 31-7952159 N3530BGlobal Avionics LLC · Downey, CABuilt 1979 · S/N 31-7912075 N35312Lam Raymond · Orlando, FLBuilt 2001 · S/N T18208015 N3532YEdwin C Poss Inc · Clayton, GABuilt 2001 · S/N T20608290 N35343Oconner Thomas Anthony · White Salmon, WABuilt 2001 · S/N T20608284 N3536BBering Capital LLC · Anchorage, AKBuilt 1979 · S/N 31-7952205 N3537WPlane Fun Inc Tr Trustee · Snellville, GABuilt 2001 · S/N T18208093 N3538RUS Department Of Homeland Security · Washington, DCBuilt 2001 · S/N T20608341 N3539UBechara Nizar E · Columbia, MDBuilt 1979 · S/N 31-7912120 N353CCThree Jay Enterprises LLC · Los Altos, CABuilt 1962 · S/N 500B-1230-105 N353SLSneaker Air Inc · Miami, FLBuilt 1979 · S/N 31-7952188 N3541FChandler Gregory E · St Albans, WVBuilt 2001 · S/N T18208078 N35438Kern County Sheriffs Department · Bakersfield, CABuilt 2001 · S/N T20608329 N35440Norwood Jon D · Damon, TXBuilt 2001 · S/N T20608327 N3544MValiair Lc Trustee · Casper, WYBuilt 1979 · S/N 31-8012005 N3545JBarr Air Patrol LLC · Mesquite, TXBuilt 2001 · S/N 18281023 N3545ZGrande Skyclub Inc · Merritt Island, FLBuilt 1979 · S/N 31-8012015 N35475Abd Corporation Inc · Tinian, MPBuilt 1979 · S/N 31-8052023 N3547BMlmce Company Inc · Winchester, VABuilt 1979 · S/N 31-8052017 N3547GCarto Flight Inc · Willoughby, OHBuilt 1979 · S/N 31-8052021

Back to AD 84-19-03 R1