Registered aircraft · 2,552

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

N22SBRamsey Timothy · Saraland, ALBuilt 1966 · S/N 310K0087 N231JPQuest Air Inc · Cocoa, FLBuilt 1975 · S/N 414-0628 N232ASGuggenair LLC · Carbondale, COBuilt 1978 · S/N 310R1369 N232RSWright Aviation LLC · Lawton, OKBuilt 1974 · S/N 310Q1145 N2345AAeolus Gold LLC · Wilmington, DEBuilt 1974 · S/N 421B0636 N234DADestination Management LLC · Tulsa, OKBuilt 1971 · S/N 421B0122 N234DWN234dw Aviation Inc · Okemos, MIBuilt 1974 · S/N 310R0008 N234MSVertical Horizon Aviation LLC · Sandown, NHBuilt 1975 · S/N 3400351 N234MWKuehn Kevin C · De Pere, WIBuilt 1964 · S/N 310I0034 N234TCAg N234tc LLC · South Salt Lake, UTBuilt 1974 · S/N 310R0050 N234TLLanflisi Robert A · Fairfield, CAS/N 310Q0957 N236ATN236at LLC · Miami, FLBuilt 1975 · S/N 414-0805 N236STOutdoor Metal Products LLC · Leighton, ALBuilt 1968 · S/N 401A0020 N237DWTheis Industrial Leasing Inc · Spivey, KSS/N 35506 N238FALetourmeau University · Longview, TXBuilt 1972 · S/N 421B0238 N239ELDingman Marine LLC · Orlando, FLBuilt 1975 · S/N 414-0808 N239SERiley Charles Sweeney · Highlands Ranch, COBuilt 1972 · S/N 421B0315 N23DTAlastrom Aviation LLC · Wilmington, DEBuilt 1975 · S/N 421B0852 N23JDraco Flight School Inc · Chino, CAS/N 310I0108 N23PFBagge Tom · Monticello, IABuilt 1968 · S/N 310P0044 N240GBSchumaker Joseph W Jr · Petersburg, MIBuilt 1966 · S/N 310K0188 N240RATop Aircraft Leasing LLC · Wilmington, DES/N 310Q0108 N240RCIntegrity Sales And Auction LLC · Merrill, WIBuilt 1980 · S/N 310R-1869 N240RTAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1975 · S/N 421B0863 N240SQMigster LLC · Miami, FLBuilt 1975 · S/N 310R0273 N241AJAircraft & Aviation Professionals LLC · Coldwater, MIBuilt 1958 · S/N 35789 N241AREllison Aviation LLC · Conroe, TXBuilt 1967 · S/N 320F-0012 N241TSGrey Matter Inc · Valley Springs, CAS/N 421B0110 N242HB2hb Airways LLC · Saint Louis, MOBuilt 1970 · S/N 421B0049 N245BMBen-Hur Air Chariots LLC · Fort Myers, FLBuilt 1971 · S/N 310Q0411 N246BGuynn Dane L · Peachtree City, GAS/N 310K0030 N246BEOn Top Aviation LLC · North Las Vegas, NVBuilt 1976 · S/N 414-0841 N247CTConsolidated Technologies · Woodbury, MNBuilt 1961 · S/N 320-0058 N247EFNobles Vernon H Jr · Calabasas, CABuilt 1968 · S/N 310P0023 N24KMNorthern Jet Inc · Iron Mountain, MIS/N 310Q0631 N24PMHaven Harmony LLC · Sheridan, WYBuilt 1973 · S/N 310Q0705 N251WWEbbert Thomas E DBA · Gary, INRegistration revokedBuilt 1967 · S/N 411-0251 N252DLPlac Holdings LLC · Paradise, TXBuilt 1975 · S/N 310R0242 N254CMGatewood Crisp · Tifton, GABuilt 1975 · S/N 310R0254 N255AOld Aircraft Inc · Lake City, FLBuilt 1956 · S/N 35285 N255MBPhoenix Aircraft Management LLC · Marathon, FLBuilt 1968 · S/N 310N-0110 N257JDAntonini Vittorio · New York, NYBuilt 1970 · S/N 310Q-0071 N25EWBas Part Sales LLC · Greeley, COBuilt 1966 · S/N 310K0063 N25FERound Trip Lc · Elkhart, KSS/N 421-0055 N25LPBer Aviation Inc · Saratoga, CABuilt 1973 · S/N 310Q0748 N25RFMlf Aviation LLC · Douglasville, GABuilt 1973 · S/N 340-0307 N2602CRrb Aviation LLC · Jasper, TXBuilt 1954 · S/N 35002 N2610CNelson Scott J · Saline, MIBuilt 1954 · S/N 35010 N261REPeterson Randy J · Sonoma, CAS/N 35284 N2631SAsplundh Eric P · Bryn Athyn, PABuilt 1979 · S/N 310R1620

Back to AD 76-08-02 R2