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.

N3330XMylin LLC · Havre De Grace, MDS/N 310L-0180 N3335XPfeiffer Engineering LLC · Boonville, MOBuilt 1967 · S/N 310L-0185 N3339XWestfall Michael T · Woodstock, GABuilt 1967 · S/N 310L-0189 N333AMLally Glen Joseph · Pleasanton, CABuilt 1975 · S/N 414-0651 N333CJDrj Aviation LLC · Dover, DEBuilt 1972 · S/N 421B0313 N333ESRebus LLC · Andover, KSS/N 310Q0232 N333HHJohnson Craig A · Canton, TXS/N 414-0942 N333JCHunter Prim LLC · Bolingbroke, GABuilt 1967 · S/N 310L-0197 N333KWD G R Air LLC · Braselton, GABuilt 1974 · S/N 421B0657 N333SFFerretti James L III · Port Orange, FLBuilt 1967 · S/N 411-0260 N333WDWoelbing Aviation LLC · Franksville, WIBuilt 1966 · S/N 310L-0002 N3340XVito Bavaro Construction Inc · Escalon, CAS/N 310L-0190 N3341XJackson Rex A · Granbury, TXBuilt 1967 · S/N 310L-0191 N3345XTurel Gary J · Tigard, ORS/N 310L-0195 N3354QOn The Beam Aviation Inc · Hampton, GABuilt 1967 · S/N 310L-0204 N3355QSunshine Aircraft Repair Inc · Lindenhurst, ILS/N 310L-0205 N3364LLopez Edwin · Germantown, TNS/N 310Q0784 N3376GLindsay Aviation Inc · West Seneca, NYBuilt 1976 · S/N 310R0818 N3377QMendez Jr Leo · Corpus Christi, TXS/N 421B0261 N337PLMaglaughlin Ronald D · Udall, KSBuilt 1969 · S/N 402A0039 N3397GPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1976 · S/N 310R0821 N3398QRiebe Grover C Jr · Gwinner, NDBuilt 1969 · S/N 421A0108 N3399QBaron Aviation Corporation · Broad Run, VABuilt 1975 · S/N 310R0304 N33ADSouthern Turf Services LLC · West Palm Beach, FLBuilt 1973 · S/N 414-0412 N33HLKnudsen Russell G · East Troy, WIBuilt 1973 · S/N 340-0315 N33LFJbo Airventures LLC · Saint Petersburg, FLBuilt 1974 · S/N 340-0352 N33UPAero Valley Properties LLC · Roanoke, TXBuilt 1961 · S/N 320-0078 N33VTTjr Aviation LLC · Orefield, PAS/N 310Q0974 N3405QHardin David A · Tukwila, WABuilt 1966 · S/N 320E-0005 N3407CK&L Leasing And Investment LLC · Mountain Green, UTBuilt 1974 · S/N 340-0506 N340ADN89vy LLC · Benson, NCS/N 340-0369 N340AGRicker David · Conway, ARBuilt 1973 · S/N 340-0205 N340BSCarey John P DBA · Marana, AZBuilt 1974 · S/N 340-0353 N340CCBeeches Of Cheyenne LLC · Cheyenne, WYS/N 340A0791 N340CHAircraft & Aviation Professional LLC · Coldwater, MIBuilt 1979 · S/N 310R1565 N340CJMcguire Frederick L · Liberty, TXBuilt 1972 · S/N 340-0108 N340CKN340ck LLC · Kalispell, MTBuilt 1973 · S/N 340-0310 N340DADreams A Loft LLC · Santa Barbara, CABuilt 1972 · S/N 340-0089 N340DFWyatt Barbara · Cheyenne, WYBuilt 1973 · S/N 340-0229 N340GSRelevance Capital Management LLC · Brentwood, TNBuilt 1972 · S/N 340-0183 N340HGVan Haitsma Kelly · Fort Worth, TXBuilt 1973 · S/N 340-0228 N340JOkla-Tex Energy Corp · Tyler, TXS/N 340-0171 N340JDWescott Aviation LLC · Prospect, KYBuilt 1972 · S/N 340-0100 N340JJAmnr LLC · Shawnee, OKS/N 340-0040 N340JPOlive Aviation LLC · Anchorage, AKBuilt 1973 · S/N 3400232 N340LBSteed Dan E Trustee · Groom, TXBuilt 1972 · S/N 340-0053 N340LZWestern Radiation Oncology Assoc Pc · Great Falls, MTBuilt 1975 · S/N 340-0537 N340NGCentral Virginia Aviation Inc · Petersburg, VAS/N 340-0042 N340PJPremier Jets Inc · Hillsboro, ORBuilt 1975 · S/N 340-0539 N340PLSummit Aircraft Sales LLC · Akron, OHS/N 340-0546

Back to AD 76-08-02 R2