Skip to content

Registered aircraft · 72,007

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.

N3517ZMeyers Carl A · Salem, CTBuilt 1960 · S/N 22-7414 N35183Stone Industrial Contractors Inc · Savannah, GABuilt 2001 · S/N 18281051 N35184Maliszewski William F · Independence, WIBuilt 2001 · S/N 18281002 N35185Stephens Brian A · Bruceville, INBuilt 1975 · S/N 17702252 N35186Mucci Eileen F · Wolcott, CTBuilt 1975 · S/N 17702253 N35187Collins Daniel W Jr · Alvarado, TXS/N 31-7912056 N3518BTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 20608163 N35191West Monte D · Coldspring, TXBuilt 1975 · S/N 17702255 N35192Huffman Robert V · Washington, DCBuilt 1975 · S/N 17702256 N35193Mccormack Duncan M · Sunfield, MIS/N 17702257 N35196Courtney Marshall Duchesne · Mission Hills, CABuilt 1975 · S/N 17702260 N35199Global Aerials Inc · Pembroke Pines, FLBuilt 1975 · S/N 17702261 N3519HGulino Thomas V · College Park, MDBuilt 1976 · S/N 20-1220 N3519ZSprott Robert L · Perkins, OKBuilt 1960 · S/N 22-7418 N351BRRosenbaum Robert · Chilmark, MABuilt 1997 · S/N 18280045 N351CPCivil Air Patrol · Maxwell Afb, ALBuilt 2004 · S/N 18281386 N351GPSelby Chris A · Monticello, ARBuilt 1968 · S/N 17256918 N351GSKukowski Matthew P · Wheatland, WYBuilt 2000 · S/N 80713 N351JDHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1997 · S/N 2707 N351JMSeal Benjamin A · Grapevine, TXBuilt 2011 · S/N 81655 N351KCErickson Jason O · Mckinney, TXS/N 25114 N351MKNorth Star Aviation · Mankato, MNBuilt 2021 · S/N 2881440 N351TBLetter Ride LLC · Woodbury, MNBuilt 1995 · S/N 1708 N351VAVictory Aviation Club Inc · Hamilton, OHBuilt 1981 · S/N 28-8111056 N351WHDean John · Marana, AZBuilt 2002 · S/N 2309 N351WTFree Bird Air LLC · Raymond, NEBuilt 1996 · S/N 4636071 N35203Sky Views Aviation LLC · Red Lodge, MTBuilt 1975 · S/N 17702263 N35206Mosaic Aviation LLC · Pelham, ALBuilt 2001 · S/N T18208089 N3520PWidner Jack A · Stanley, NCBuilt 1955 · S/N 22-3274 N3520WLyttle John W Jr · Chehalis, WABuilt 1966 · S/N 32-404 N3520XGv Air Inc · Medford, ORBuilt 1979 · S/N 31-7912067 N3520ZWaldo Charles N · West Ossipee, NHBuilt 1960 · S/N 22-7420 N35211Ballester Alexis R · Mayaguez, PRBuilt 1975 · S/N 17702267 N35213Aviation Adventure LLC · Munster, INBuilt 1975 · S/N 17702268 N35218Chessare Gary M · Caledonia, ILBuilt 1975 · S/N 17702270 N35219Nelson Laurel L · Renton, WABuilt 1975 · S/N 17702271 N3521KState Of North Carolina · Raleigh, NCBuilt 2002 · S/N 18280998 N3521MNationwide Aviation LLC · Hudson Oaks, TXBuilt 1978 · S/N 28-7816350 N3521PJet Jam LLC · Layton, UTBuilt 1955 · S/N 22-3275 N3522Barnett Charles J · St Peter JerseyBuilt 1969 · S/N 30-1787 N35220Spoor John B Jr · Sandwich, ILBuilt 1975 · S/N 17702272 N35225Nguyen Ricky L · Honolulu, HIS/N 17702275 N35229Coneburripul Corp · Miami, FLBuilt 2001 · S/N 172S8837 N3522EKilgore William B · Eureka, CAS/N 17271572 N3522KAsap Realty LLC · Stroud, OKS/N 28-23608 N3522NRegistration Pending · Mandeville, LARegistration pendingBuilt 1967 · S/N 680082 N3522PBurling Daniel J DBA · Warsaw, NYBuilt 1955 · S/N 22-3276 N3522QRamirez Jose Marcos · Casa Grande, AZBuilt 1973 · S/N 17261661 N35230Christiansen Aviation LLC · Wilmington, DEBuilt 2001 · S/N 17281017 N35238Williams E E · Atlanta, GABuilt 1975 · S/N 17702283

Back to AD 87-10-06 R1