Skip to content

Registered aircraft · 2,554

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:76-08-02-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:76-08-02-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:76-08-02-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:76-08-02-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:76-08-02-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:76-08-02-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.

N888KPRunway 321 LLC · Hilton Head Island, SCBuilt 1977 · S/N 310R0918 N888NNorman James R · San Diego, CABuilt 1973 · S/N 340-0312 N888RCLeahy Kyle Bergen · Dallas, TXS/N 310I0067 N888TZollman Garry L · Pendleton, ORBuilt 1959 · S/N 35925 N888VVAbaco Xpress LLC · West Palm Beach, FLBuilt 1973 · S/N 421B0550 N88JBJr Aviation LLC · Benton, KSBuilt 1969 · S/N 310P0174 N88KGSky West Aviation Inc Trustee · Albuquerque, NMS/N 340-0510 N88LTRyan M Kearbey Dental Corp · Oroville, CABuilt 1973 · S/N 310Q0835 N88RNInternational Air Services Inc Trustee · Carson City, NVS/N 310J-0077 N88XCollins Ken W · Olympia, WAS/N 35075 N8904ZBuess Wayne R · Shirley, NYBuilt 1961 · S/N 310G0004 N8906ZGrismer Jeff Trustee · Hemet, CABuilt 1961 · S/N 310G0006 N8908ZLevin Robert G · Roseburg, ORBuilt 1961 · S/N 310G0008 N8909ZSumthin Limited · Wilmington, DEBuilt 1961 · S/N 310G-0009 N890GRFly Compton Aeronautical Education Foundation · Compton, CAS/N 310H0130 N8910ZRazorhawk LLC · Birmingham, ALBuilt 1961 · S/N 310G0010 N8911ZSt Francis Aircraft LLC · Montrose, COBuilt 1961 · S/N 310G0011 N8923ZPanting Edwin A · Anchorage, AKBuilt 1962 · S/N 310G-0023 N8927ZEast Texas Aircraft Engines LLC · Palestine, TXBuilt 1962 · S/N 310G-0027 N8928ZSwanson Garret C · Valentine, NEBuilt 1962 · S/N 310G0028 N8930NReprop LLC 310 Series · Wilmington, DEBuilt 1977 · S/N 310R0986 N8932ZMclynn Matthew J · Green Valley, AZBuilt 1962 · S/N 310G-0032 N8934ZJeppson Edward Mckay Trustee · South Jordan, UTBuilt 1962 · S/N 310G-0034 N8939ZJenkins John C · Chocowinity, NCBuilt 1962 · S/N 310G-0039 N8941ZUplands Aviation Management LLC · Mineral Point, WIBuilt 1962 · S/N 310G-0041 N894JGMeasured Approach LLC · Wooster, OHBuilt 1972 · S/N 340-0098 N8956ZN8956z LLC · Brighton, COBuilt 1962 · S/N 310G-0056 N8962ZMorris Russell L · Fort Myers, FLBuilt 1962 · S/N 310G-0062 N8965ZMathison John M · Del Norte, COBuilt 1962 · S/N 310G0065 N8976ZProsperity Properties Ltd · Southlake, TXBuilt 1962 · S/N 310G0076 N8979ZKimbrel Mark D · Rochester, WABuilt 1962 · S/N 310G0079 N8982ZEverett Dwight H · Pauma Valley, CABuilt 1962 · S/N 310G0082 N8986ZPremier Capital Enterprises LLC · Hurricane, UTS/N 310G0086 N8987ZRobinson Mark V · Vacaville, CABuilt 1962 · S/N 310G0087 N898EPMarcy Michael S · Farmington, NMBuilt 1973 · S/N 421B0429 N898TCRomar LLC · Myrtle Beach, SCBuilt 1966 · S/N 310K0084 N8993ZBrutus Adrien J · Grove City, OHS/N 310G0093 N8995ZRidgway Rick J · Carlisle, INBuilt 1962 · S/N 310G0095 N8AVOtis Air Service Inc · Wichita, KSBuilt 1974 · S/N 421B0663 N8BFEight Bravo Foxtrot LLC · Shafter, CAS/N 310J0140 N8BLPro One Janitorial Inc · Chicken, AKBuilt 1970 · S/N 414-0098 N8EHMcdougall Butch · Pocatello, IDFirst renewal noticeBuilt 1965 · S/N 320C0063 N8EPN8ep LLC · Spring Hill, FLBuilt 1973 · S/N 310Q0967 N8FBRichland Aviation Inc · Sidney, MTBuilt 1978 · S/N 402B1372 N8HMMetco Builders LLC · Edmond, OKS/N 414-0620 N8KJBenjabr Inc · Fresno, CANon-citizen corporation, flight hours not reportedBuilt 1978 · S/N 310R1392 N8SSWeather Modification LLC · Fargo, NDBuilt 1973 · S/N 340-0191 N8TCSvenningsen Joshua J · Spring Hill, FLS/N 310Q0264 N8WBSmartin Enterprises LLC · Clackamas, ORBuilt 1974 · S/N 421B0594 N900GMKashtan David L · Mill Valley, CABuilt 1977 · S/N 310R1249

Back to AD 76-08-02 R2