Skip to content

Registered aircraft · 54,015

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-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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.

N757RATorello Marty A · Port Huron, MIBuilt 1978 · S/N 15279933 N757RJCenter Brian · Garwood, TXBuilt 1976 · S/N 18264805 N757RLRudak Phillip Richard · Wethersfield, CTBuilt 1977 · S/N 15279943 N757RNSky Aviation & Maintenance Inc · Wildomar, CAS/N 15279945 N757RPBoyne Valley Flyers Club Inc · Boyne Falls, MIBuilt 1977 · S/N 15279946 N757RSRegistered aircraftBuilt 1978 · S/N R18200308 N757RTEnright Darren R · Lakeville, MNBuilt 1977 · S/N 15279950 N757RYSale Reported · Corona, CASale reportedS/N R18201260 N757RZCox Derrell L · Pamplico, SCS/N 15279956 N757SCHicks Byron · Manchaca, TXBuilt 1977 · S/N 15279959 N757SDYu Hermon Lemuel C · Mays Landing, NJBuilt 1977 · S/N 15279960 N757SP4e Aviation LLC · Alpine, UTS/N R18201261 N757SQByrne Sarah Boltz · Dallas, TXBuilt 1979 · S/N R18201262 N757STChester Charter Inc · Chester, CTBuilt 1977 · S/N 15279974 N757SWSt Charles Flying Service Inc · Portage Des Sioux, MOBuilt 1977 · S/N 15279977 N757TAHofmeister Laurence C · Punta Gorda, FLBuilt 1977 · S/N 15279981 N757TDNew Horizon Aviation Inc · Warwick, RIBuilt 1977 · S/N 15279984 N757THGoodrich Pilot Training Center LLC · Johnson City, NYBuilt 1977 · S/N 15279988 N757TLSky Candy LLC · Scottsdale, AZBuilt 1977 · S/N 15279991 N757TVTri County Rentals And Sales Inc · Lake City, FLBuilt 1977 · S/N 15280000 N757UDDau Anuar · Colfax, NCBuilt 1977 · S/N 15280007 N757UFAviation Capital Management LLC · San Jose, CABuilt 1977 · S/N 15280009 N757URRichmor Aviation Inc · Hudson, NYBuilt 1977 · S/N 15280018 N757UTIfly LLC · Wichita, KSBuilt 1977 · S/N 15280020 N757UZCoulliette Brian K · Jacksonville, FLBuilt 1977 · S/N 15280026 N757VAStoup Lyndal K · Cordell, OKS/N 15280027 N757VBGanesh Prabhandhakavi · Cerritos, CABuilt 1977 · S/N 15280028 N757VVTechnical Education Services Inc T/A · Virginia Beach, VAS/N 15280046 N757VWHeckert Dale L · Nikiski, AKBuilt 1977 · S/N 15280047 N757VYRice Timyn J · Saint Petersburg, FLBuilt 1979 · S/N R18201268 N757WBReineke John S · Powell, OHBuilt 1979 · S/N R18201269 N757WKKuersteiner William C · Panacea, FLBuilt 1962 · S/N 17249290 N757WPAero Fliers LLC · Kalispell, MTS/N 15280064 N757WTElectrical Management Services · North Andover, MABuilt 1979 · S/N R18201230 N757XDSouth Texas War Birds LLC · Santa Fe, TXBuilt 1979 · S/N R18201272 N757XGJohnson Shawn A · Joliet, MTBuilt 1977 · S/N 15280081 N757XHSteinhauser Raymond P · Ashland, OHBuilt 1977 · S/N 15280082 N757XUHighflight Inc · Perkinsville, VTBuilt 1979 · S/N R18201273 N757XWPittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1977 · S/N 15280095 N757YARule John D · Nampa, IDS/N 15280099 N757YGDayton Pilots Club Inc · Springboro, OHBuilt 1979 · S/N R18201274 N757YHKnutson Wayne R · Thompson, NDFirst renewal noticeS/N 15280106 N757YMDarcy Aviation LLC · Danbury, CTS/N 15280110 N757YSJohn Mccaskill Enterprises LLC · Tifton, GABuilt 1977 · S/N 15280115 N757YUTechnical Education Services Inc T/A · Virginia Beach, VABuilt 1977 · S/N 15280117 N757ZAAdventure Flight Aviation Inc · Springdale, ARBuilt 1977 · S/N 15280123 N757ZFProbasco Mitchell L · Floydada, TXS/N 15280128 N757ZNJin Jin Aviation LLC · Anchorage, AKBuilt 1977 · S/N 15280135 N757ZRBishops' Ltd · Virginia Beach, VABuilt 1977 · S/N 15280138 N757ZSDevereaux Mishelle · Raleigh, NCBuilt 1977 · S/N 15280139

Back to AD 87-20-03 R2