Registered aircraft · 4,001

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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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.

N64SN81c Corp LLC · Wilmington, DES/N P3370179 N65025Killian Larry D · Hampton, ARS/N R172-0123 N6508CMurphy Matthew · Anchorage, AKBuilt 1978 · S/N 28R-7803233 N6516CBarsocchini Albert P · Friday Harbor, WABuilt 1978 · S/N 28R-7803234 N6527CSunrise Site Development Corp · Bristow, VABuilt 1978 · S/N 34-7870163 N6534CMccarthy John P · Lutz, FLBuilt 1978 · S/N 28R-7803235 N654LBWilliamson Donovan J · Black Hawk, SDBuilt 2007 · S/N 7129 N6557CFox Kilo Aviation Corp · Pompano Beach, FLNon-citizen corporation, flight hours not reportedBuilt 1976 · S/N 347670184 N655CFCarter James W · Dyersburg, TNBuilt 1964 · S/N 337-0016 N657CDRegistered aircraftS/N 1596 N65CGAirplanesusa LLC · Schaumburg, ILBuilt 1981 · S/N 34-8233004 N65EBKansas Farm & Ranch In · Seneca, KSBuilt 1977 · S/N R1722331 N65NDJhkh LLC · Ponte Vedra Beach, FLBuilt 2004 · S/N 1390 N65PMKummer Mark · Hayden, IDBuilt 1982 · S/N 24-1312 N65SKenyon Ray · Sherburne, NYBuilt 1974 · S/N P3370166 N65WPWarnken James V · Pleasanton, TXBuilt 1977 · S/N R1722232 N66003Nesheim William A · Holderness, NHBuilt 1979 · S/N R1723000 N6612EReeser Michael C · Paige, TXBuilt 1959 · S/N 56112 N661DCParts Catalog Holding LLC · Clearwater, FLBuilt 1977 · S/N 28R-7703244 N6628DSummer Air LLC · Greenville, SCBuilt 1979 · S/N MC-672 N662KC216 Skymaster Series LLC · Keller, TXS/N P3370216 N6631RCornelius Craig R · West Hartford, CTFirst renewal noticeBuilt 1974 · S/N MC-313 N663GGNt Miller LLC · Winchester, KYBuilt 1975 · S/N 33701634 N668MCCooper Michael T · Manson, IABuilt 2011 · S/N 73168 N668MKAlta Wings LLC · Longmont, COBuilt 1982 · S/N 25-0668 N669GAWilson Victor A · New Albany, OHS/N R172-0200 N66MEDm Asset Management LLC · Plain City, OHBuilt 1977 · S/N R1722298 N66PJ66pj LLC · Atwater, CABuilt 2000 · S/N 1098 N66RJShapiro Mathew J · Clarkrange, TNS/N 25-0497 N670AMyers Matthew D · Gilbert, AZS/N 34-33136 N670DLLoomis Aviation Inc · Sarasota, FLBuilt 2002 · S/N 1171 N6719FMichalek Zackery · Myrtle Beach, SCBuilt 1976 · S/N 34-7770034 N675LBOmalley Kevin S · Cordova, MDBuilt 1977 · S/N 28R-7703389 N676CDAero Leasing LLC · Glendale, AZBuilt 2005 · S/N 1563 N678CWPlane Fun Inc Tr Trustee · Snellville, GABuilt 1978 · S/N 34-7870236 N678EHHolen Endre · Las Vegas, NVBuilt 2002 · S/N 2823 N679XChagres Aero LLC · Albuquerque, NMBuilt 1977 · S/N 28R-7703101 N67RAKirkwood Billie R · El Paso, TXS/N R172-0090 N67SSchultz Daniel A · Tipp City, OHBuilt 1974 · S/N P3370168 N6831JHogan Thomas J · San Diego, CABuilt 1976 · S/N 34-7670282 N683AAPlane Fun Inc Tr Trustee · Snellville, GABuilt 1979 · S/N 250105 N6841JStarnes Robert D · Lavonia, GABuilt 1976 · S/N 34-7670283 N6850JBush J Scott · Grindstone, PABuilt 1976 · S/N 34-7670293 N685VAlpha Golf Flyers Inc · Wilmington, DEBuilt 1976 · S/N P3370265 N686QPZero2knots Aviation LLC · Canal Winchester, OHBuilt 1979 · S/N 28R-7931289 N68773Barnett Paul S · Brookhaven, MSBuilt 1950 · S/N 6008 N6878CWisconsin Aviation Inc · Watertown, WIBuilt 1978 · S/N 34-7870166 N687AVNeal Jeffrey Jay · Scottsdale, AZBuilt 2000 · S/N 3449180 N687TJMirarchi Joseph F · New Braunfels, TXBuilt 1977 · S/N 28R7703235 N688PCSea J Aviation LLC · Vernon, CTBuilt 2004 · S/N 1450

Back to AD 81-13-10 R1