Registered aircraft · 54,841

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

N111ATSkymaster Stc LLC · Mena, ARBuilt 1969 · S/N 337-1125 N111BLLandry Patrick Todd · Georgetown, TXFirst renewal noticeBuilt 1979 · S/N 18503877 N111BXDonadio Robert F · Amherst, NHBuilt 1972 · S/N 414-0368 N111CAce'S Hangar LLC · Bentonville, ARBuilt 1974 · S/N 18502600 N111CJRegan Dennis W · Rochester, MNFirst renewal noticeBuilt 1973 · S/N 18262621 N111CYSmody Michael S · Neelyville, MOBuilt 1974 · S/N 18263183 N111DEPespisa John · Hacienda Heights, CABuilt 1973 · S/N 18262712 N111EAExecutive Air Inc · Roanoke, VAS/N 310R0245 N111EXNew Orleans Aviation LLC · Covington, LABuilt 1986 · S/N 17275024 N111EYHook Steven · Pasco, WABuilt 1974 · S/N 18502407 N111EZMayes Robert C · Boise, IDBuilt 1964 · S/N 1850753 N111FFGutierrez Isaias · Fontana, CAS/N R18200807 N111GN111g LLC · Longmont, COBuilt 1974 · S/N 18502507 N111GFHuggins Stephen M · Eagle Creek, ORBuilt 1975 · S/N 18263578 N111GTMorgan Gerald W · Hillsboro, TXS/N 340-0188 N111HCBennett Miranda Mathis · Fairhope, ALBuilt 1975 · S/N 15077675 N111HPFlying Aces Aero-Fleet Inc · Guyton, GABuilt 1984 · S/N 172RG1153 N111HSMacav Flight Training LLC · Abilene, TXBuilt 1965 · S/N 17253989 N111HVBga-Viation · Bennettsville, SCBuilt 1979 · S/N R1723289 N111JJTextron Aviation Inc · Wichita, KSS/N 208B5988 N111KBSale Reported · Mexico D FSale reportedS/N 18261460 N111KSKilo Sierra LLC · Monticello, INS/N 56476 N111KULot-A-Go Six LLC · Polson, MTBuilt 1985 · S/N 425-0226 N111LHSuperior Aviation Gateway LLC · Tampa, FLBuilt 1977 · S/N 17269965 N111MFField Monica · Los Angeles, CABuilt 1963 · S/N 17250162 N111NCDaxair Aviation LLC · Scottsdale, AZBuilt 1975 · S/N 310R0182 N111NJNew Jersey Forest Fire Service · Trenton, NJBuilt 1964 · S/N U206-0278 N111PJG&L Aviation Services LLC · Las Vegas, NVBuilt 1981 · S/N 340A1234 N111PWKilgore Eric M · Genoa, NVS/N T210-0066 N111RBClear Skies LLC · Allentown, PABuilt 1978 · S/N 340A0545 N111RKSan Carlos Flight Center Inc · San Carlos, CABuilt 1977 · S/N 15280874 N111RRCook David C · Orlando, FLBuilt 1973 · S/N 18261539 N111SA111sa LLC · Greeley, COBuilt 1972 · S/N 17260937 N111SDMarc Inc · Bolton, MSBuilt 1969 · S/N 310P0200 N111SRPayne John A · Bloomington, ILBuilt 1981 · S/N 18268005 N111TBNeswest Inc · Los Angeles, CABuilt 1968 · S/N 15069477 N111TFPacific Aviation Aircraft Management Inc · Ontario, ORBuilt 1974 · S/N 421B0660 N111TKMclendon Thomas A · Crockett, TXBuilt 1968 · S/N 17257828 N111TLNdk Global Holdings Corp · Dover, DEBuilt 1974 · S/N 421B0645 N111WFArnold Frank W · Senoia, GABuilt 1954 · S/N 31243 N111WLCj Aero LLC · Fort Valley, VABuilt 1973 · S/N 18052407 N111ZUsda Forest Service · Boise, IDS/N U20602919 N111ZYSkywarrior Flight Training Inc · Pensacola, FLBuilt 1986 · S/N 17276611 N112Central Copters Inc · Belgrade, MTBuilt 2026 · S/N 208B5960 N11204Hudson Daryl J · Redwood Valley, CABuilt 1973 · S/N 15075252 N11208Cape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1973 · S/N 15075255 N11209Pendragon Aviation LLC · Sylvania, GABuilt 1973 · S/N 15075256 N1120DCompher Charles D · Berryville, VABuilt 1966 · S/N 17254131 N1120FHaidle Wayne M · Bismarck, NDBuilt 1966 · S/N 17254715 N1120VKodiak Marine Construction · Oakley, IDBuilt 1976 · S/N U20603130

Back to AD 97-01-13