Skip to content

Registered aircraft · 54,837

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.

N1276VNew Horizon Aviation Inc · Warwick, RIBuilt 1984 · S/N T30300262 N1276YJet Rider LLC · Middletown, DEBuilt 2005 · S/N 208B1113 N12772Bell Ornithopters Flying Club Inc · Eastlake, COBuilt 1973 · S/N 17262245 N12776Oviedo Juan · Oak Point, TXBuilt 1973 · S/N 17262249 N12777Mana Kai Flying LLC · Makawao, HIBuilt 1973 · S/N 17262250 N12779Mile High Flyers Club Inc · Fort Valley, VABuilt 1973 · S/N 17262252 N1277FJohn D Strohsahl Pa Trustee · Fort Lauderdale, FLBuilt 1979 · S/N 17272982 N1277MWilliams Richard A · Brookhaven, GABuilt 1970 · S/N 33701277 N127826350 LLC · Yorklyn, DES/N 17702387 N12783American Patrols Inc · Midland, TXBuilt 1973 · S/N 17262256 N12789Marshall Frederic J · Rochester, NYBuilt 1973 · S/N 17262261 N1278SSac Exec LLC · Sacramento, CABuilt 1976 · S/N 18264846 N12790Cdb Group Holdings LLC · Sheridan, WYBuilt 1973 · S/N 17262262 N12791Neo Flites Flying Club Inc · Elmhurst, ILBuilt 1973 · S/N 17262263 N12793Arpey Gerard J · Colleyville, TXBuilt 1973 · S/N 17262264 N12794Mccain Michael G · Barstow, CABuilt 1973 · S/N 17262265 N12795Rl Aviation LLC · Miami, FLBuilt 1973 · S/N 17262266 N12796Skylens LLC · Hammond, LABuilt 1973 · S/N 17262267 N1279GHodgman Gary W · Greenville, TXBuilt 1974 · S/N 310Q1129 N1279MSturdy Wings Aviation LLC · Mcpherson, KSBuilt 1975 · S/N 18264272 N1279QCerrit LLC · Helena, MTBuilt 1971 · S/N 15072579 N1279SCavu Aviation LLC · Haiku, HIBuilt 1976 · S/N 18264847 N127ARAircraft Unlimited Inc · Pierre, SDBuilt 2004 · S/N 208B1055 N127EDRussell Robert Q · Genoa City, WIBuilt 1980 · S/N 15284797 N127EPAnnonsen Johnny · Dix Hills, NYBuilt 1985 · S/N 172-76481 N127ETThomas Eric C · Boise, IDBuilt 1982 · S/N 18268234 N127FRYoon Paul · Saint David, AZS/N 17275292 N127KGardner Victoria S · Port Saint Lucie, FLBuilt 1960 · S/N 17248076 N127KDSouthmost Aviation Inc · Brownsville, TXBuilt 1976 · S/N 17267210 N127MBBerger Max · Daytona Beach, FLBuilt 1976 · S/N 310R0654 N127RFRandigo LLC · Wilmington, DEBuilt 1993 · S/N 208B0350 N127RLSkylane Of Ohio LLC · London, OHS/N 18262910 N127TJRegistration Pending · Bowersville, GARegistration pendingBuilt 1978 · S/N 18266629 N127VCSmith Von T · Chelan, WABuilt 1967 · S/N 18258041 N12801Cone Ted · Wayne, NJBuilt 1973 · S/N 17262271 N12805Bemidji Aviation Services Inc · Bemidji, MNBuilt 1973 · S/N 17262275 N1280GSky Aviation And Consulting · Panorama City, CABuilt 1976 · S/N 310R0692 N1280YAutumn Crucus LLC · Cincinnati, OHS/N 15059680 N12813Razor Aviation Corp · Kalispell, MTBuilt 2000 · S/N 208B0808 N12819Stewart Todd L · Mooresville, NCS/N 17262288 N1281MWadleigh John M · Marana, AZBuilt 1970 · S/N 33701281 N1281SChief Cornerstone LLC · Billings, MTBuilt 1976 · S/N 18264849 N12820US Aviation Group LLC · Denton, TXBuilt 1973 · S/N 17262289 N12821Hayslett Norman L · Roscoe, MOBuilt 1973 · S/N 17262290 N12822Courtney Aviation LLC · Columbia, CABuilt 1973 · S/N 17262291 N1282FRainbow River Lodge Aviation LLC · Alpine, UTS/N 18502806 N1282URutledge James K Trustee · Colfax, CABuilt 1976 · S/N 17266977 N1282YShewalter Nicholas · Frankfort, MIS/N 15059682 N12830All Sports Aviation LLC · Spokane, WABuilt 1973 · S/N 17262296 N12831Bryant Kevin L · Terry, MSBuilt 1973 · S/N 17262297

Back to AD 97-01-13