Registered aircraft · 25,370

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N1899QAlvord Jeffrey C · Tucker, GABuilt 1972 · S/N 177RG0299 N1899SBuon Volo LLC · Queen Creek, AZBuilt 1971 · S/N 177RG0045 N189BCross X Country LLC · Great Falls, VABuilt 1998 · S/N 1246-98 N189BCEph LLC · Eagle, IDS/N 470-2005 N189DCWorthan Gary T Trustee · Storm Lake, IABuilt 1976 · S/N 177RG0927 N189PCN189pc LLC · Heber City, UTBuilt 2005 · S/N 1006-2005 N189RANiles Bruce C · Oneida, TNBuilt 2003 · S/N 1348-2003 N18DTKit Air LLC · Waconia, MNS/N 431-99 N18EBAll American Aviation LLC · East Helena, MTBuilt 1974 · S/N 17264188 N18ENOdonnell Daniel V · Dover, DEBuilt 1974 · S/N 477-74 N18FGShapiro David Ely · Brookhaven, GABuilt 1974 · S/N 17264233 N18HDDifilippo Dennis · Hico, WVBuilt 1999 · S/N 846-99 N18HTTobler Niccolo Sunny · Anchorage, AKS/N 15282364 N18JAJahawk Leasing LLC · Sugar Grove, ILBuilt 1980 · S/N 17274513 N18JKTalley Warbirds Inc · Longview, TXBuilt 1969 · S/N 690020 N18NCJohnson Thomas G · New Port Richey, FLBuilt 2003 · S/N 938-2003 N18NJTennessee Dept Of Saftey & Homeland Security · Nashville, TNBuilt 1978 · S/N R18200178 N18STYoung Shawna Hodges · Turlock, CABuilt 1973 · S/N 17261795 N18XMUfer John M · Truman, MNBuilt 1973 · S/N 621-74 N1900UBismarck Aero Center · Bismarck, NDBuilt 1979 · S/N 17273162 N1900YMarrero Francisco J · Lake Charles, LABuilt 1964 · S/N 2684 N1902YFlowers John H · Laurel, MSBuilt 1964 · S/N 287 N1903QMatter Gregory · Sherman, TXBuilt 1972 · S/N 177RG0303 N1905VNew Horizons Aviation Inc · Goshen, INBuilt 1974 · S/N 17263788 N1906VN46132 LLC · Kalispell, MTBuilt 1974 · S/N 17263789 N1907QSimmons Marilyn K · Wilmington, DEBuilt 1972 · S/N 177RG0307 N1908FMccloskey Cynthia · Matthews, NCBuilt 1973 · S/N 17256493 N19093Gedney Douglas Kevin · Issaquah, WAS/N 17702556 N1909QHarper Donald W · Odenton, MDBuilt 1972 · S/N 177RG0309 N190JTravel Services LLC · Metropolis, ILBuilt 2014 · S/N 1142-2014 N19103Mashburn Paul M · Cumming, GABuilt 1976 · S/N 17702557 N19119Rose Randy J · Egg Harbor, WIBuilt 1976 · S/N 17702559 N1911HAdair Aviation LLC · Mountain Home, ARBuilt 1980 · S/N R18201550 N1914VStephens Thomas E · Blacklick, OHBuilt 1974 · S/N 17263792 N1915VBenac Brad James · Swansea, SCS/N 17263793 N1917QMeester Mark L · Intl Falls, MNBuilt 1972 · S/N 177RG0317 N1918VCampbell Kevin A · Grayville, ILBuilt 1974 · S/N 17263794 N1919FUsda Forest Service Fepp · Columbia, SCBuilt 1979 · S/N 17273011 N1919QErickson Bernard L · Moses Lake, WABuilt 1972 · S/N 177RG0319 N1919SBurgess Reilly M · Greene, MEBuilt 1974 · S/N 17263899 N191ABRegistration Pending · Newport, ORRegistration pendingBuilt 1963 · S/N 2471 N191ACLoewen Jason Scott · Wenatchee, WABuilt 1993 · S/N 711-93 N191ARJack Dixon Inc · Haiku, HIBuilt 1977 · S/N 17270069 N191DJScallion Leon Ivy · Pine Bluff, ARBuilt 1965 · S/N 3206 N191DMOlson Tim O · Saint Onge, SDBuilt 1999 · S/N 426-99 N191FSSouthern Illinois University Board Of Trustees DBA · Murphysboro, ILBuilt 1984 · S/N 15285939 N191HCTrinair Aviation LLC · Hampshire, ILBuilt 1965 · S/N 2992 N191PCBad Attitude LLC · Lisbon, OHBuilt 2002 · S/N 896-2002 N191RAKellander Thomas N · Fairmont, MNBuilt 2007 · S/N 511-2007 N191SHHutton Stephen · Madison, MSBuilt 1968 · S/N 17257232

Back to AD 80-25-07 R1