Skip to content

Registered aircraft · 442

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:80-22-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-22-13') 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:80-22-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-22-13')
  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:80-22-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-22-13')
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.

N2550PRobinson Mark V · Vacaville, CABuilt 1979 · S/N 38-79A1020 N2552DKindred Heather · Dania, FLBuilt 1978 · S/N 38-79A0368 N25596Phelps Charles R · Princeton, KYS/N 38-81A0009 N2560NMcquack Aviation LLC · Belding, MIBuilt 1979 · S/N 38-79A0913 N25623Pilots Choice Aviation Equipment Leasing Co · Georgetown, TXBuilt 1981 · S/N 38-81A0048 N2563DBeckhoff Allen C · Greybull, WYBuilt 1978 · S/N 38-79A0376 N2564NKern Raymond · Bedford, INBuilt 1979 · S/N 38-79A0923 N25671Westphal Martin W · Cecil, WIBuilt 1981 · S/N 38-81A0045 N2569COswalt Nicholas J · Caro, MIS/N 38-79A0232 N256KALarson Home Builders LLC · Klamath Falls, ORBuilt 1978 · S/N 38-78A0759 N2571EStrojny Andrew P Jr · Strongsville, OHBuilt 1978 · S/N 38-78A0578 N25743Maile Frank W · Hamilton, NJBuilt 1981 · S/N 38-81A0072 N25746Collins Ronald Rs · Rutledge, TNBuilt 1981 · S/N 38-81A0069 N25759Rogers Samuel I · Le Roy, KSBuilt 1981 · S/N 38-81A0071 N2579DAnywhere Atp LLC · Mt Juliet, TNBuilt 1978 · S/N 38-79A0361 N257KAWikle Thomas A · Stillwater, OKBuilt 1979 · S/N 38-79A1004 N2580BGarcia Edwin · Mckinney, TXBuilt 1978 · S/N 38-79A0131 N2584ASorrells David · Gladewater, TXBuilt 1978 · S/N 38-78A0765 N2586AInternational Air Services Inc Trustee · Carson City, NVS/N 38-78A0766 N2586BAnderson Miles D · Reno, NVBuilt 1978 · S/N 38-79A0133 N2586DStay-Air-Borne LLC · Locust Grove, GABuilt 1978 · S/N 38-79A0385 N2587CRegistration Pending · Kalispell, MTRegistration pendingBuilt 1978 · S/N 38-79A0245 N2587DLindee Thomas W · Minnetonka, MNBuilt 1978 · S/N 38-79A0386 N2587NExecutive Air Leasing Inc · Minneapolis, MNBuilt 1979 · S/N 38-79A0932 N2588DThurmond Georgette E · Palmdale, CABuilt 1978 · S/N 38-79A0387 N25895Registered aircraftBuilt 1981 · S/N 38-81A0080 N2589BOsterman Jeremiah E · Sautee, GAS/N 38-79A0135 N2590CKelley Judson R · Olympia, WABuilt 1978 · S/N 38-79A0247 N2590GAnywhere Atp LLC · Mt Juliet, TNBuilt 1979 · S/N 38-79A0560 N2591GRivero Mark A · Henderson, NVBuilt 1979 · S/N 38-79A0563 N25929Trevisan Hugo S · Polk City, FLBuilt 1981 · S/N 38-81A0105 N2592LLondke Kevin S · Lexington Park, MDBuilt 1979 · S/N 38-79A0774 N2594NDivinity Enterprises LLC · Wilmington, DEBuilt 1979 · S/N 38-79A0933 N25959South Texas Air Force LLC · Mission, TXS/N 38-81A0087 N2596BWynn Ralph H · Tulsa, OKBuilt 1978 · S/N 38-79A0143 N2596EMeigs Jonathan H · Corning, NYBuilt 1978 · S/N 38-78A0483 N26008Off LLC · Lonoke, ARBuilt 1981 · S/N 38-81A0097 N2602ABrisker Geoffrey H · Wheelersburg, OHBuilt 1978 · S/N 38-78A0772 N2603BCafiero Vincent B · Haskell, OKBuilt 1978 · S/N 38-79A0147 N26045Wyant James O · Sanford, NCBuilt 1981 · S/N 38-81A0112 N2605DRealty Investment Co Ltd · Hilo, HIBuilt 1978 · S/N 38-79A0392 N2606LMatts Services LLC · Chicago, ILBuilt 1979 · S/N 38-79A0778 N2607NPiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 38-79A0940 N2609EMakotyn Andrzej · Northbrook, ILBuilt 1978 · S/N 38-78A0486 N338SJMiller Space A · Simi Valley, CAS/N 38-79A0500 N381AVNelson Allen R · Oakdale, MNS/N 38-78A0638 N382CFTurner Noah S · Gilbert, AZBuilt 1979 · S/N 38-79A1043 N382PTTechnical Education Services Inc · Virginia Beach, VABuilt 1978 · S/N 38-78A0003 N38PRK&M Industry LLC · Winston Salem, NCS/N 38-78A0780 N39CFFedrigo John A · Moneta, VAS/N 38-79A0765

Back to AD 80-22-13