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.

N1942GBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 421B0842 N1944GBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 421B0844 N1946GPartwin421 LLC · Greenwich, CTBuilt 1974 · S/N 421B0846 N1956Sturges George S Jr · Bakersfield, CABuilt 1956 · S/N 35337 N196RLunsford Joel T · Jasper, TXBuilt 1955 · S/N 35049 N196TCClements Dylan A · Burlington, WIBuilt 1980 · S/N 310R1801 N197DB310 Flyers LLC · Lafayette, LAS/N 310R1809 N1987GPhillips Michael M · Angleton, TXBuilt 1974 · S/N 414-0544 N1995GHarris Justin R · Hico, TXBuilt 1974 · S/N 414-0602 N19AFBegley Edward R · Glasgow, KYBuilt 1966 · S/N 310K0100 N19DBDcs Air LLC · Pulaski, WIBuilt 1972 · S/N 310Q0668 N19DJLewis Landon Jon · Hope, NDBuilt 1977 · S/N 310R0868 N19LFN19lf Corp · Oak Lawn, ILBuilt 1972 · S/N 310Q0622 N1GQAero Attack Systems (USA) Inc · Blaine, WANon-citizen corporation, flight hours not reportedBuilt 1972 · S/N 421B0236 N1YASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1974 · S/N 421B0580 N1YCMay Thomas W · Texarkana, TXBuilt 1976 · S/N 310R0621 N200LEAeromarine Holdings LLC · Waukesha, WIBuilt 1979 · S/N 310R1842 N200MCN200mc Inc Trustee · Cheyenne, WYBuilt 1973 · S/N 414-0424 N200SHHoward Steve · Jefferson City, MOBuilt 1979 · S/N 310R1601 N20162Wateractive43 LLC · Auburn, CABuilt 1974 · S/N 310Q-1004 N202ZLojas Phillip · San Ysidro, CAS/N 411-0292 N203BNCarlson Curt · Lake Havasu City, AZBuilt 1980 · S/N 310R2101 N204KMInternational Air Services Inc Trustee · Carson City, NVS/N 340-0070 N208VBas Part Sales LLC · Greeley, COBuilt 1975 · S/N 421B0866 N20EZRegistration Pending · Bigfork, MTRegistration pendingBuilt 1969 · S/N 310P0078 N20MWStriebel David J · Dayton, OHBuilt 1975 · S/N 421B0918 N20NGTas Aviation Of Defiance Inc · Defiance, OHBuilt 1971 · S/N 310Q0276 N20VKEvans Jeffrey L · Mansfield, LABuilt 1977 · S/N 310R0978 N20WFLofton Christopher L · Harlingen, TXBuilt 1976 · S/N 310R0684 N210FCBaked Industries Inc · Yuba City, CABuilt 1975 · S/N 421B0908 N213JDS&C Vending LLC · Scottsbluff, NES/N 310R0136 N213MRogers Ronald J · Crystal Lake, ILBuilt 1978 · S/N 310R1335 N21430Burns Preston · Spruce Pine, ALBuilt 1990 · S/N 310Q1073 N214DFGaylord Hangars LLC · Gaylord, MIBuilt 1973 · S/N 421B0461 N214WGriffeth John · Branson, MOBuilt 1969 · S/N 310Q0061 N215AMurphy Dan A · Two Harbors, MNBuilt 1954 · S/N 35013 N216LBBail Air LLC · Port Saint Lucie, FLBuilt 1974 · S/N 414-0545 N217BSRegistration Pending · Nogales, AZRegistration pendingBuilt 1963 · S/N 310H0034 N218USouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 310Q0507 N2199CMorris Thomas B · Imlay City, MIBuilt 1958 · S/N 38081A N21CSHendrix Peter A · Plantation, FLBuilt 1973 · S/N 310Q0963 N21FC310 Pals LLC · Lake City, FLBuilt 1974 · S/N 310Q1080 N21GBSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 310R-1580 N21GFBas Part Sales LLC · Greeley, COBuilt 1971 · S/N 421B-0209 N21HAEngle Scott · Plymouth, MNS/N 310R1850 N21KBLow Carl S III · Aurora, TXBuilt 1973 · S/N 310Q0777 N21MTTarrant County College · Fort Worth, TXBuilt 1967 · S/N 320F-0017 N2207FAnderson Mike DBA · Muskogee, OKS/N 310L-0007 N220BRSimmonds Gary Bert · San Antonio, TXBuilt 1977 · S/N 310R0973 N220HDAce Transport Service Inc · Wilmington, DEBuilt 1975 · S/N 310R0593

Back to AD 76-08-02 R2