Registered aircraft · 22,416

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

N8285YAmerican Aviation Inc · Woods Cross, UTFirst renewal noticeBuilt 1980 · S/N 28-8190073 N82864Meyer Fredric Kim · Orange, CABuilt 1982 · S/N 28-8316005 N8286BHigh Altitude Ministries LLC · Blythewood, SCBuilt 1980 · S/N 28R-8118019 N8286CMidwest Sky Chasers Nfp · Algonquin, ILBuilt 1975 · S/N 28-7690110 N8286NAyyildiz Erol · Glen Rock, NJBuilt 1969 · S/N 28-25503 N8287NBetik Patrick G · Grapevine, TXS/N 28-25504 N8287YLocust Hill Aviation LLC · Lewes, DEBuilt 1980 · S/N 28-8111020 N8288AJohnson Carmen · White Cloud, MIBuilt 1982 · S/N 28-8390020 N8288FAtwood Jason P · La Porte, INBuilt 1976 · S/N 28-7790237 N8288LFrenzel Aviation Investments LLC · Brentwood, TNBuilt 1980 · S/N 28R-8118011 N8288ZPabon Hugo · Granada Hills, CABuilt 1980 · S/N 28-8116071 N8289AAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1980 · S/N 28-8116072 N8289XSheitelman Mitchell · Warren, NJBuilt 1980 · S/N 28-8190080 N828BJOrth Robert John · Garland, TXBuilt 1980 · S/N 28R-8031108 N828CRRegistration Pending · East Greenwich, RIRegistration pendingBuilt 1981 · S/N 28-8111087 N828JMJr Aviation LLC · Tulsa, OKBuilt 1979 · S/N 28-7911126 N828LBBeraut Olivier Trustee · Scotts Valley, CABuilt 1972 · S/N 32-7240077 N828MCHub City Aviation Academy LLC · Lubbock, TXBuilt 1968 · S/N 28-4615 N828SRGulfcoast Aviation Inc · Wilmington, DEBuilt 1978 · S/N 32R-7887169 N82906Hunt Bryan W · Louisville, KYBuilt 1982 · S/N 28R-8231069 N82908Hall Charles R · Leawood, KSBuilt 1982 · S/N 32-8324001 N8290NHorne Larry E · Suffolk, VABuilt 1969 · S/N 28-25508 N8290WCastles James D · Portland, ORBuilt 1965 · S/N 28-2452 N8290XMorrison Preston L · Findlay, OHBuilt 1980 · S/N 32-8106007 N82910Great Bay Air LLC · North Hampton, NHBuilt 1982 · S/N 32R-8313006 N8291NPeters Rodney A Jr · Hayward, WIBuilt 1969 · S/N 28-25509 N8291WVoll Dorothe A · Corona, CABuilt 1965 · S/N 28-2454 N82921New Hampshire Flying Association Inc · Nashua, NHBuilt 1982 · S/N 28-8390007 N8292DHuffman Jacob M III · Burleson, TXBuilt 1982 · S/N 28-8316009 N8292TJames Peterson Sons Inc · Medford, WIBuilt 1982 · S/N 32R-8329001 N8292WPinegar Kevin R · Brighton, MIBuilt 1965 · S/N 28-2455 N82933Cummings Jake A · Tucson, AZBuilt 1980 · S/N 28-8111023 N8293NPaul Harvey B · Kongiganak, AKBuilt 1969 · S/N 28-25511 N8293PGrosshans Inc · Central City, NEBuilt 1980 · S/N 28-8111021 N8293XIsland Bound LLC · Dunedin, FLS/N 28-8111022 N8294KAdvantage 94 Kilo LLC · Grosse Pointe Park, MIBuilt 1980 · S/N 32R-8113007 N8294LAts Tennessee Inc · Oneida, TNBuilt 1982 · S/N 28-8316011 N82953Sky Fox Aircraft LLC · Queen Creek, AZBuilt 1980 · S/N 28-8190088 N82954Phoenix Air LLC · Hemet, CABuilt 1980 · S/N 28R-8118025 N8295HAnywhere Atp LLC · Mt Juliet, TNBuilt 1982 · S/N 28-8316013 N8295NMaust Philip J · Hemet, CABuilt 1969 · S/N 28-25514 N8295TFlight Services Inc · Headland, ALBuilt 1980 · S/N 28-8116082 N8295WHess Stephen L · Millerton, PAFirst renewal noticeBuilt 1965 · S/N 28-2459 N8295ZWhitaker Stephen P · Northville, MIBuilt 1980 · S/N 28-8190087 N82965Mockingbird Flying Club · Sioux Falls, SDBuilt 1980 · S/N 32-8106011 N82967Spare Joseph T · Waldo, OHBuilt 1980 · S/N 32R-8113013 N8296NCline Terence P · Alva, OKBuilt 1969 · S/N 28-25515 N8296PBarto Eric K · Kula, HIBuilt 1982 · S/N 32-8206039 N8296WAngert Phillip E · New York, NYBuilt 1965 · S/N 28-2460 N8297NShowman Christopher D · Frisco, TXBuilt 1969 · S/N 28-25516

Back to AD 87-08-08 R3