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.

N421GGScientific Flight Corp · Shorewood, ILBuilt 1974 · S/N 421B0848 N421GHArx Aviation LLC · Apopka, FLBuilt 1973 · S/N 421B-0483 N421GRInvestors Management LLC · Fort Payne, ALBuilt 1993 · S/N 421B0597 N421GWGrinnell Allen L · Derry, NHBuilt 1974 · S/N 421B0873 N421HHNunez Salvador · Calexico, CAS/N 421B0661 N421HMGottshall Curt · Monroe, WABuilt 1970 · S/N 421B0029 N421HRRons Air Service Inc · Two Buttes, COS/N 421B0945 N421HZDickert Investments - Flying Dicks LLC · Cave Creek, AZBuilt 1972 · S/N 421B0260 N421JMSchuck James M · Downey, CABuilt 1975 · S/N 421B0956 N421KSEnvironmental Manufacturing Solutions Ltd · Melbourne, FLBuilt 1973 · S/N 421B0507 N421MCBlue Bottom Inc · Los Angeles, CABuilt 1972 · S/N 421B0321 N421MRQuest Aviation Inc · Lake City, FLBuilt 1968 · S/N 421-0112 N421MWRice Melvin Gaylon · Bridgeport, TXBuilt 1968 · S/N 421-0058 N421MYOzark Trails Youth Services Inc · West Plains, MOS/N 421B-0356 N421PDDavis Paul · Rockwall, TXBuilt 1975 · S/N 421B0960 N421PFNorthwest Georgia Aviation LLC · Rome, GAS/N 421B0400 N421PZGloria Bachelder Md Pc DBA · Erie, COBuilt 1974 · S/N 421B0806 N421RCSeremet Sasa · Beaver Dam, WIS/N 421B0604 N421RDMunn Laurie P · Bellflower, CABuilt 1968 · S/N 421-0157 N421RHWorld Tradex Inc · Missoula, MTS/N 421B0605 N421RLSmith Ronald · Murfreesboro, TNBuilt 1968 · S/N 421A0026 N421RMEagle Air LLC · North Myrtle Beach, SCBuilt 1969 · S/N 421A0069 N421RRBlue Star Aviation LLC · Billings, MTBuilt 1968 · S/N 4210085 N421SEQuonset Aviation LLC · North Kingstown, RIBuilt 1973 · S/N 421B0393 N421SHShepard Gregory W · Fort Myers, FLS/N 0080 N421TMEdelman Seth · Gig Harbor, WABuilt 1974 · S/N 421B0659 N421VCEr Aviation LLC · Brazil, INS/N 421B0428 N421VVTower Aviation Management LLC · Wilmington, DEBuilt 1975 · S/N 421B0959 N421WDKilo Aviation LLC · East Peoria, ILBuilt 1973 · S/N 421B0469 N421WXCeaco Inc · Las Vegas, NVS/N 421B0262 N421YPWateractive43 LLC · Auburn, CAS/N 421B0511 N421ZSale Reported · Glen Allen, VASale reportedBuilt 1968 · S/N 421-0077 N4228CBurhmann Joel David · Justin, TXBuilt 1974 · S/N 414-0528 N4235CColville LLC · Signal Mountain, TNBuilt 1974 · S/N 414-0534 N4237CBreakaway Group Aviation LLC · Franklin, TNBuilt 1974 · S/N 414-0535 N4251TJett Shelby Kerman · Pewee Valley, KYFirst renewal noticeS/N 421B0533 N4258CSonrise Aviation LLC · Portland, INBuilt 1978 · S/N 310R1386 N4264JBellamy Mark A · Freeville, NYBuilt 1975 · S/N 310R0201 N4266Uber Robert Eric · Pittsburgh, PABuilt 1956 · S/N 38088 N42776Hap'S Air Inc · Ames, IABuilt 1973 · S/N 421B0394 N427CAChippewa Aerospace Inc · Gainesville, FLBuilt 1976 · S/N 310R0653 N428DLGiair LLC · Morristown, TNBuilt 1976 · S/N 310R0657 N42BCRotary Components International Inc · Houston, TXBuilt 1975 · S/N 421B0922 N42BJRegistration Pending · Oakland Park, FLRegistration pending, pending cancellationBuilt 1972 · S/N 421B0342 N42NCCapair Inc · Plantation, FLBuilt 1973 · S/N 402B0387 N42SGPolar Star Co · Wilmington, DES/N 4140927 N42SSBas Part Sales LLC · Greeley, COBuilt 1972 · S/N 310Q0682 N42WSOrlandella Vito · Auberry, CABuilt 1955 · S/N 35143 N42YZPharaoh Aviation LLC · Velma, OKBuilt 1973 · S/N 421B0385 N431BRLockyer Roch Jr · Austin, TXBuilt 1970 · S/N 310Q0221

Back to AD 76-08-02 R2