Skip to content

Registered aircraft · 6,916

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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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.

N7638JSeward Charles Ryan · Nashville, INBuilt 1968 · S/N 28R-31037 N7638YScientific Motive Systems Inc · Charlevoix, MIBuilt 1965 · S/N 30-717 N7639FArrona David M · San Luis Obispo, CABuilt 1976 · S/N 32R-7780068 N7639JCampbell Ronald David · Etna, WYBuilt 1968 · S/N 28R-31038 N7639YCaviris Homestead Farm LLC · Rollinsford, NHBuilt 1965 · S/N 30-718 N7641JFrazier Michael K · Abbeville, GABuilt 1968 · S/N 28R-31041 N7642JUniversal Technical Institute Inc · Coppell, TXBuilt 1968 · S/N 28R-31042 N7642PCollins Daniel R · Klamath Falls, ORBuilt 1961 · S/N 24-2856 N7644PWhobrey Andrew · Bee Spring, KYBuilt 1961 · S/N 24-2858 N7645JArrow 8 LLC · Chicago, ILBuilt 1969 · S/N 28R-31045 N7645YN7645y LLC · Sheridan, WYBuilt 1966 · S/N 30-1236 N7646JRavotti Air LLC · Leechburg, PABuilt 1968 · S/N 28R-31046 N7648YFingerlakes Wing And Rotor LLC · Seneca Falls, NYBuilt 1965 · S/N 30-726 N7649FPadilla Jeffrey S · Lehigh Acres, FLS/N 32R-7780072 N764JBLance Aviation Inc · Lakeland, FLBuilt 1976 · S/N 32R-7680506 N7650FPinnacle Air Charter Inc · Blair, NEBuilt 1976 · S/N 34-7770061 N7650JAmsg Transport LLC · Southfield, MIS/N 28R-31050 N7652JCamilo Rafael Gonzalez Moya · Fort Worth, TXS/N 28R-31052 N7652POso Air LLC · Missoula, MTBuilt 1961 · S/N 24-2734 N7652YMetro West Ambulance · Hillsboro, ORBuilt 1965 · S/N 30-730 N7653JGulley Peter M · Karnes City, TXBuilt 1969 · S/N 28R-31053 N7653PThomason Tony L · Williamson, GABuilt 1961 · S/N 24-2703 N7654JGarrison Trading LLC · Prescott, AZBuilt 1969 · S/N 28R-31054 N7656JBurton David N · Pittsgrove, NJBuilt 1968 · S/N 28R-31056 N7656PAnkney Gary L · Rector, PABuilt 1961 · S/N 24-2869 N7658JGarner Kenneth W · Decatur, ALBuilt 1969 · S/N 28R-31058 N7659JEdwards Robert B Jr · Macon, GABuilt 1968 · S/N 28R-31059 N765CBJillco Enterprises Inc · Wilmington, DEBuilt 1971 · S/N 28R-7135052 N7660PRegistered aircraftBuilt 1961 · S/N 24-2873 N7661JMitchell Edson · El Dorado Hills, CABuilt 1970 · S/N 28R-31061 N7662JBurns Christopher Jason Gary · Natrona Heights, PABuilt 1969 · S/N 28R-31062 N7662PRemund Richard W · Slate Hill, NYBuilt 1961 · S/N 24-2875 N7664JTrue Arrow Aviation LLC · Cloverdale, CABuilt 1970 · S/N 28R-31063 N7664PSandpiper Aviation LLC · Carson City, NVBuilt 1961 · S/N 24-2877 N7664YSummit Flight Academy LLC · Peculiar, MOBuilt 1965 · S/N 30-742 N7666JCavallaro Jack C · Jordan, NYBuilt 1968 · S/N 28R-31065 N7669POkst George S · Slate Hill, NYBuilt 1961 · S/N 24-2882 N766VKWave Golf LLC · Kimberly, ALBuilt 1977 · S/N 32R-7780271 N7670PSale Reported · Edenton, NCSale reportedS/N 24-2883 N7671YBailey Wryan T · Nashville, TNBuilt 1965 · S/N 30-749 N7672JWeiner Johannes · New Paltz, NYBuilt 1969 · S/N 28R-31103 N7672PSantore William F · Laguna Niguel, CABuilt 1961 · S/N 24-2885 N7672YBertrand Jason · Seattle, WABuilt 1965 · S/N 30-750 N7674CFiyalko Wayne · Fort Myers, FLBuilt 1975 · S/N 28R-7635111 N7674JAerofeather Aviation Inc · Suffolk, VABuilt 1968 · S/N 28R-31074 N7674PChurches Michael D · Smyrna, TNS/N 24-2887 N7674YBooth James R · Nevada City, CABuilt 1965 · S/N 30-752 N7675JDimmlich Scot A · Conyers, GABuilt 1968 · S/N 28R-31075 N7675PEhrhart Jerry L · Mount Joy, PABuilt 1961 · S/N 24-2844 N7676PHanneman Robert D · Denver City, TXBuilt 1961 · S/N 24-2845

Back to AD 97-01-01 R1