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.

N2130TWasson Ronald L · Colleyville, TXBuilt 1971 · S/N 28R-7135073 N2131TMullin Thomas F III · Birmingham, ALBuilt 1971 · S/N 28R-7135111 N2134TBartow Municipal Airport Development Authority · Bartow, FLBuilt 1971 · S/N 28R7135142 N2135TPeter Prince Aviation Center LLC · Milton, FLBuilt 1971 · S/N 28R-7135139 N21382Rodriguez Carlos Mendoza · Paramount, CABuilt 1978 · S/N 34-7870434 N2139TFlight School Of Gwinnett Inc · Lawrenceville, GABuilt 1971 · S/N 28R-7135145 N213SALatrobe Aviation Enterprises LLC · Youngstown, PABuilt 1973 · S/N 28R-7435138 N2141THorizon Ventures Inc · Red Oak, IABuilt 1971 · S/N 28R-7135144 N2145MHanscom Afb Aero Club · Hanscom Afb, MAS/N 28R-7837069 N214CALester Don · Campton, NHBuilt 1974 · S/N 28R-7435281 N214JMVisions In Design LLC · Fairmont, WVBuilt 1977 · S/N 28R-7703059 N214JNFox-1 Drafting & Design Inc · Eagan, MNBuilt 1966 · S/N 30-1130 N214RLlano Charles · Lakeland, FLBuilt 1977 · S/N 32R7780522 N2153MBlocklin Bruce · Port Charlotte, FLBuilt 1977 · S/N 28R-7803110 N2155MMchatton Dret A · Redding, CABuilt 1977 · S/N 28R-7803111 N2158VDe Sousa Jorge Norberto Freitas · Cape Coral, FLBuilt 1978 · S/N 28R-7803151 N2159SOutfront Aviation LLC · Merritt Island, FLBuilt 1979 · S/N 34-7970144 N215JDShapiro Jonathan · New York, NYBuilt 1976 · S/N 32R7680241 N215RMKevin W Singletary & Associates LLC · Little River, SCBuilt 1977 · S/N 28R-7703219 N2166MMiller Harry B · Fisherville, TNBuilt 1977 · S/N 34-7870070 N216GCSch Aviation Inc Trustee · Sporle Kings LynnBuilt 1971 · S/N 28R-7135151 N2172MPacker Bruce P Trustee · Tempe, AZBuilt 1963 · S/N 24-3305 N21788Kenco Associates Inc · Ashland, KYBuilt 1978 · S/N 34-7870450 N217HCSwartzendruber Brett E · Hesston, KSBuilt 1963 · S/N 30-166 N21870Tezaguic-Swanson Olga I · Wichita Falls, TXBuilt 1978 · S/N 28R-7837309 N218SAInternational Air Services Inc Trustee · Carson City, NVS/N 24-1877 N218WGWilliams Sydney E · Kendallville, INBuilt 1969 · S/N 28R-35345 N218WPGriffin Kurt J · Gardnerville, NVS/N 28R-7803217 N2190KArnold Mark W · Columbus, OHBuilt 1978 · S/N 34-7970096 N219TGXin Han Aviation LLC · Atwater, CABuilt 1972 · S/N 34-7250315 N21ASBoa Properties LLC · Valdosta, GABuilt 1968 · S/N 28R-30862 N21LKDalton Versel Jr · Fort Myers, FLBuilt 1973 · S/N 28R-7335207 N21PAHensley Aviation LLC · Telford, TNS/N 30-1255 N21QSParsons Ray · Abilene, TXBuilt 1976 · S/N 34-7670181 N21YCPattillo John · Cocoa, FLBuilt 1977 · S/N 34-7770375 N22042Lemish Michael · Cedar Hill, TXBuilt 1978 · S/N 34-7870454 N2204TNgugi Samson W · El Paso, TXBuilt 1971 · S/N 28R-7135168 N2205WSasnak Inc · Wichita, KSBuilt 1978 · S/N 34-7870132 N220LLife Chiropractic And Wellness Center Inc · Prudenville, MIBuilt 1977 · S/N 32R-7780393 N220MGCornwell Anne L · Athens, OHBuilt 1978 · S/N 28R-7837156 N2210QSymphony Air LLC · Medford, NYBuilt 1977 · S/N 32R-7780234 N2212DMichel David L · Greenville, SCBuilt 1973 · S/N 28R-7335443 N2218UF & D Leasing Limited · East Liverpool, OHBuilt 1979 · S/N 34-7970152 N221CSTriple Seven Aviation LLC · Newark, DEBuilt 1977 · S/N 32R-7780424 N221DFMoeckel Herbert R · Tunas, MOBuilt 1958 · S/N 24-242 N221GHWitham Aviation LLC · Stuart, FLBuilt 1976 · S/N 32R-7680502 N221SDKimball James R · Indian Trail, NCBuilt 1974 · S/N 28R-7535081 N221WGLove Kenneth J · CombaningnswBuilt 1976 · S/N 32R-7680478 N2222ZParsons John C · Wichita, KSBuilt 1963 · S/N 24-3388 N2226TRegistration Pending · Tucson, AZRegistration pending, pending cancellationBuilt 1971 · S/N 28R-7135171

Back to AD 97-01-01 R1