Skip to content

Registered aircraft · 54,019

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.

N19913Wings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 17260857 N19914Ursa Major Holdings LLC · Newark, DEBuilt 1981 · S/N 18053181 N19916Barbour Benjamin E · Huntersville, NCS/N 17260859 N1991PMyron Holdings LLC · Puyallup, WAS/N 18263326 N1991QJohnny Becker LLC · Helotes, TXS/N 177RG0391 N1991XTree-O LLC · Daphne, ALBuilt 1965 · S/N 18256091 N19928Gibson Christopher R · Natchez, MSBuilt 1972 · S/N 17260866 N1992XBush Richard A · Mccall, IDBuilt 1965 · S/N 18256092 N19934Falcons Flying Club Inc · Ridgefield, WABuilt 1972 · S/N 17260869 N19936Halsted Barry J Trustee · Sequim, WABuilt 1972 · S/N 17260870 N19938Chamberlain Cory D · Holladay, UTBuilt 1973 · S/N 17260871 N1993CSpencer John S · Indian, AKBuilt 1953 · S/N 26138 N1993MPoskey Charles E · Alabaster, ALBuilt 1976 · S/N 18264522 N1993QCasper Aire Inc · Saint Cloud, FLBuilt 1973 · S/N 177RG0393 N19940Elk & Ram Aviation Group LLC · San Antonio, TXBuilt 1972 · S/N 17260873 N19944Gray Richard B · Manley Hot Springs, AKBuilt 1972 · S/N 17260875 N19947Sprynx Aviation LLC · Plano, TXBuilt 1972 · S/N 17260877 N19948Murray Air LLC · Patoka, ILBuilt 1972 · S/N 17260878 N19949Skipper Martin D · Orlando, FLBuilt 1972 · S/N 17260879 N1994MAgile Aviation LLC · Rotonda West, FLBuilt 1976 · S/N 18264523 N1994UBoney C Steven · Bethel, AKBuilt 1970 · S/N 18501761 N1994XCovenant Flyers LLC · Sharpsburg, GAS/N 18256094 N1994ZGoldberg Marc Fred · Chandler, AZS/N 15059794 N19954Aslam Obaid M · Houston, TXBuilt 1972 · S/N 17260884 N19955Sayre Reid L · Raleigh, NCBuilt 1972 · S/N 17260885 N19956Gulfstream Boats Inc · Cortez, FLBuilt 1972 · S/N 17260886 N19958Snell Arthur R · York, PAS/N 17260887 N1995CBorror Timothy A · Wshngtn Ct Hs, OHBuilt 1954 · S/N 26140 N1995QHooper Jonathan P · Andrews, NCBuilt 1973 · S/N 177RG0395 N1995URegistered aircraftBuilt 1970 · S/N 18501764 N19962Koosman Shawn · Dresser, WIBuilt 1972 · S/N 17260891 N19967Bdc Aero LLC · Miami, TXS/N 17260895 N1996CGoodwin James A · Greeley, COBuilt 1953 · S/N 26141 N1996MHarrison Dan H · Englewood, FLBuilt 1976 · S/N 18264525 N1996USmith Aviation LLC · Sitka, AKBuilt 1970 · S/N 18501765 N1996ZEvans Christopher L · Summerville, SCBuilt 1962 · S/N 15059796 N19971Woitas Jody R · Rogers, ARBuilt 1972 · S/N 17260898 N19972Virzi Michael A · Independence, OHBuilt 1972 · S/N 17260899 N19976West Mi Shooting Alliance For Excellence In Safety · Marne, MIS/N 17702618 N19977Moody Matthew Joseph · Homewood, ALBuilt 1977 · S/N 17702619 N19978Rydeout Aviation LLC · Lake Placid, FLBuilt 1973 · S/N 17260905 N1997CTravelaire Service Inc · Pueblo, COBuilt 1954 · S/N 26142 N1997EOlsen Grain & Livestock Inc · Whitewater, MTBuilt 1978 · S/N 17271114 N19982Hayton James B · Sedro Woolley, WABuilt 1972 · S/N 17260909 N19983Twin Falls Fliers Inc · Twin Falls, IDBuilt 1972 · S/N 17260910 N19987Sprinz Steven B · Rimrock, AZBuilt 1972 · S/N 17260914 N19988Havener Ronald R · Overland Park, KSBuilt 1972 · S/N 17260915 N1998MExecutive Aviation LLC · Peoria, AZBuilt 1976 · S/N 18264527 N1998VLedbetter Zachary S · Wasilla, AKBuilt 1973 · S/N U20602035 N1998XBlue Sky Powers N1998x LLC · Dover, DEBuilt 1965 · S/N 18256098

Back to AD 87-20-03 R2