OpenAirDocs.org
AD 51-07-01

Registered aircraft · 746

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
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:51-07-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:51-07-01')
  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.

N10133Fisher Charles R Jr · San Antonio, TXBuilt 1948 · S/N NAV-4-1766N10145Hensarling Matthew L · Elizabeth, COBuilt 1948 · S/N 48-999N1046WGoodin Ross W Jr · Enterprise, MSS/N NAV-4-54N10552Jed Homes Inc · Lisbon, CTS/N NAV-4-1078N105ERSokoloski James J · Lampasas, TXBuilt 1947 · S/N NAV-4-521N1069Byrne Sofia V · Merrimack, NHBuilt 1948 · S/N NAV-4-1775N107SWanagel Walter · Lisbon, CTBuilt 1949 · S/N NAV-4-1946N10894Holcomb Daniel F · Galena, ILS/N NAV42333BN109DSBell Bradley L · Bothell, WABuilt 1948 · S/N NAV-4-1373N1102VRaimondi Jennifer Le · Rancho Murieta, CAS/N NAV-4-2089N111KMJohnston Cheryle L · El Centro, CABuilt 1946 · S/N NAV-4-324N118AANorthern Valley Air Ltd LLC · Long Island, KSS/N NAV-4-110N11FZHolguin Steven · Hayward, CABuilt 1946 · S/N NAV-4-263N1208UPulliam Anthony L · Lancaster, CABuilt 1949 · S/N 1803N124RMGolden Dreams LLC · Missoula, MTBuilt 1946 · S/N NAV-4-136N134WBMeaux Frederick · Port Neches, TXS/N NAV-4-2034N137MFHuston Lee E · Graham, WABuilt 1948 · S/N NAV-4-1605N14SXMiller Randy · Greer, SCBuilt 1946 · S/N NAV-4-416N15CPBedingfield John R · Piedmont, SDBuilt 1948 · S/N NAV-4-1243N17VYVallee Jean-Francois R · Everson, WAS/N NAV-4-461N182PGaines Robert M · Nashville, TNBuilt 1956 · S/N NAV-4-1246N188PABradley Max T II · West Plains, MOBuilt 1949 · S/N NAV-4-1979N191Lubecke Robert D · Oconomowoc, WIBuilt 1950 · S/N NAV-4-2033N1947UTri Pacer Air LLC · Pennington, NJBuilt 1946 · S/N NAV-4-394N1CSMoseley Ailsa · Wellington, FLBuilt 1946 · S/N NAV-4-106N1YPLovelace Patricia Executor · San Angelo, TXBuilt 1950 · S/N NAV-4-2154BN20000Madshack Naviation LLC · Reston, VABuilt 1958 · S/N NAV-4-1787N20SHCsw LLC · Anacoco, LAS/N 4-131N212LInternational Air Services Inc Trustee · Carson City, NVBuilt 1948 · S/N NAV-4-1159N222LWSlocum Jon M · Newaygo, MIBuilt 1949 · S/N NAV-4-1899N225ELetsom Steven D · Eugene, ORBuilt 1948 · S/N NAV-4-1160N225HJMao Darwin · Las Vegas, NVS/N NAV-4-188N22AWare Steven E Trustee · Lonoke, ARBuilt 1946 · S/N NAV-4-19N22VSchadler Alletta M · Fredericksburg, PABuilt 1949 · S/N NAV-4-866N269CCAngeloff Lawren J · Escanaba, MIBuilt 1946 · S/N NAV-4-269N26UOtt Dean R · Carrollton, OHS/N NAV4-1275N2778AFeather Gerald B · Grand Junction, COS/N NAV-4-862N27AWBold William H Jr · Annapolis, MDBuilt 1950 · S/N 4-2172BN285HPGaines Robert M · Nashville, TNBuilt 1949 · S/N NAV-4-1968N285TCSickinger Alan W · New Philadelphia, OHBuilt 1947 · S/N NAV-4-473N2882DPacific Coast Air Museum · Santa Rosa, CAS/N NAV-4-1938N2893DAshurst Brent H · Westmorland, CABuilt 1951 · S/N 2242BN292MDDean Ryan · Fresno, CABuilt 1946 · S/N NAV-4-116N2995CAmerican Airpower Heritage Flying Museum · Dallas, TXBuilt 1948 · S/N NAV-4-1727N29CDSea Aerospace Ground Evaluations Inc · Harpers Ferry, WVBuilt 1950 · S/N NAV-4-2088N29PNavion West Inc · Northridge, CABuilt 1951 · S/N NAV-4-2320BN2FMWyatt Scott J · Anchorage, AKBuilt 1949 · S/N NAV-4-1914N2WDBrantley Scott R · Great Bend, KSBuilt 1950 · S/N NAV-4-2153-BN300CBAerial Ads Of Pittsburgh Inc · Allison Park, PABuilt 1950 · S/N NAV-4-2237BN301Southwest Plane Holdings LLC · Kalispell, MTS/N NAV-4-1167
Back to AD 51-07-01