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.

N56680Sky III Corporation · Smyrna, TNBuilt 1973 · S/N 28R-7435027 N56682Hogan David · Simpsonville, SCBuilt 1973 · S/N 28R-7435028 N56686Paris Air Inc · Vero Beach, FLBuilt 1973 · S/N 34-7450021 N56690Shreeve Michael W · Port Orange, FLBuilt 1973 · S/N 28R-7435029 N56696Sterling Oliver James III · Hancock, NHBuilt 1973 · S/N 28R-7435030 N5669VChildress Rheyce · Gainesville, TXS/N 32R-7780356 N566BSSand Farm Management Services LLC · Adel, IABuilt 1970 · S/N 39-56 N56701Eros Aviation Ventures LLC · Oakland Park, FLS/N 34-7450023 N5670PBas Part Sales LLC · Greeley, COBuilt 1959 · S/N 24-742 N56720Precision Flight Training Inc · Newberg, ORBuilt 1973 · S/N 28R-7435034 N5674PNeely Antwuan T · Savoy, ILBuilt 1959 · S/N 24-746 N56755Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1973 · S/N 34-7450029 N5675PLandolt Gregg E · Moreno Valley, CAFirst renewal noticeBuilt 1959 · S/N 24-747 N5676XArmstrong Kyle John · Eugene, ORBuilt 1973 · S/N 28R-7435039 N5677VAnnies Aviation LLC · Bloomington, INBuilt 1977 · S/N 32R-7780359 N56780Stewart Donald Kent · Denver, NCBuilt 1973 · S/N 28R-7435041 N56782Avie Ation LLC · Suwanee, GABuilt 1973 · S/N 34-7450031 N5678PWhite John O · Camarillo, CABuilt 1959 · S/N 24-750 N56790Bradfield Breyson · Mandaree, NDBuilt 1973 · S/N 28R-7435042 N56791Brosher Melvin G · Decaturville, TNS/N 28R-7435043 N5679PKuehnert Stefan · Clarkesville, GABuilt 1959 · S/N 24-751 N567DSJones Dean F · Long Beach, CABuilt 1977 · S/N 28R-7703414 N567TCRegistration Pending · Platteville, WIRegistration pending, pending cancellationBuilt 1970 · S/N 39-63 N56822Tanner Timothy S · Norton, KSBuilt 1973 · S/N 28R-7435047 N56823Fly Tu9 LLC · Vancouver, WABuilt 1973 · S/N 28R-7435048 N56834Maslonka Bradley James · Prior Lake, MNBuilt 1973 · S/N 28R-7435049 N5684PAce Drilling LLC · Johnson, KSBuilt 1959 · S/N 24-756 N5684VShrauner Biggs Taylor · Gulf Breeze, FLS/N 28R-7703148 N56853Maxair Complex Flight LLC · Murfreesboro, TNBuilt 1973 · S/N 28R-7435050 N56864Odom Joseph L Jr · Lake Mary, FLBuilt 1973 · S/N 28R-7435052 N5686PGray Gary L · Frederick, OKBuilt 1959 · S/N 24-758 N5687VColescott Zachary A · Cleveland, TNBuilt 1977 · S/N 34-7770261 N56888Ameer & Zaki Aircraft Solutions LLC · Lewes, DEBuilt 1973 · S/N 28R-7435056 N56889Red Choochoo LLC · Madison, INBuilt 1973 · S/N 28R-7435057 N568WFCruz Norman D · Las Vegas, NVBuilt 1976 · S/N 32R-7680264 N5691PCoady Michael · Taylorville, ILBuilt 1959 · S/N 24-763 N5692VI N K M & Associates Lllp · Columbia, MOBuilt 1977 · S/N 32R-7780362 N5693PBays Aviation LLC · Boerne, TXBuilt 1959 · S/N 24-766 N56951American Home Realty Services Inc · Lincoln, CAS/N 28R-7435062 N56972Eby Aviation LLC · Duluth, GABuilt 1973 · S/N 28R-7435067 N56991Schneider Stephen C · Denton, TXBuilt 1973 · S/N 28R-7435070 N56992Attebery Larry J · Caldwell, IDBuilt 1973 · S/N 28R-7435071 N5699PHahn Curtis D · St George, UTBuilt 1959 · S/N 24-772 N56CCMichel David L · Pickens, SCBuilt 1959 · S/N 24-1297 N56EB56 Eb Inc · Jacksonville, FLBuilt 1968 · S/N 28R30647 N56GSScott Daily Inc · Ash Flat, ARS/N 32R-7780097 N5700PEdmundson George · Burlington, WABuilt 1959 · S/N 24-773 N5702PChilds Group Inc · Altoona, IABuilt 1959 · S/N 24-775 N5705PN5705p Inc · Pompano Beach, FLBuilt 1959 · S/N 24-778 N5709PSaadjack LLC · Amelia Island, FLBuilt 1959 · S/N 24-783

Back to AD 97-01-01 R1