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.

N40NYJohnson Elite International LLC · Tucson, AZBuilt 1970 · S/N 414-0160 N41019Sjs Flights Lp · Columbus, GABuilt 1973 · S/N 421B0401 N41041Mathews Christopher D · Blue Earth, MNBuilt 1973 · S/N 421B0412 N41055J&B Aircraft LLC · Anaheim, CABuilt 1974 · S/N 421B0576 N41085421 Bravo LLC · Marine City, MIS/N 421B0440 N4108QStuckle Gary W · Davenport, WABuilt 1967 · S/N 310N-0008 N410ECSoutheast Enterprises LLC · Dothan, ALBuilt 1973 · S/N 421B0422 N410WMFlying Life LLC · Middleburg, FLBuilt 1975 · S/N 310R0578 N41106Delorenz Robert J · Boca Raton, FLBuilt 1974 · S/N 421B0589 N41114Iacobacci Timothy R · Fairborn, OHBuilt 1973 · S/N 421B0458 N41124Wenta Nip & Sanitizing LLC · Monte Vista, COBuilt 1973 · S/N 421B0465 N411DCWillert Fred J · San Diego, CABuilt 1965 · S/N 411-0135 N411GCadwell Bradley L · Orlando, FLBuilt 1964 · S/N 310I0125 N411STwin Adventures LLC · Cincinnati, OHBuilt 1972 · S/N 340-0099 N411SMKonkel Bernard · Kalispell, MTBuilt 1978 · S/N 310R1404 N411TBLewis Nathan · North Plains, ORS/N 421B0481 N411VTvc Aviation Inc · Lebanon, OHBuilt 1973 · S/N 340-0250 N411ZJkdj LLC · Tyler, TXBuilt 1973 · S/N 421B0482 N4120QJade Air LLC · Middle River, MDS/N 310N-0020 N4122QV V S Implements LLC · Wilmington, DEBuilt 1967 · S/N 310N-0022 N4123TRace Dean · Chicken, AKBuilt 1966 · S/N 320D0023 N4127QHurd Aviation LLC · Lexington, KYBuilt 1967 · S/N 310N-0027 N412DGJannelli Gilbert DBA · Clearwater, FLS/N 35690 N412SJRegistration Pending · La Place, LARegistration pendingS/N 310-0037 N4130TSteven J Leavitt · Avondale, AZS/N 320D0030 N4132QKarlen John R IV · Edwards, CABuilt 1967 · S/N 310N-0032 N4133QGaston Prentice W Jr · Carmel, INBuilt 1967 · S/N 310N-0033 N4135TNehls Chevrolet Olds Cadillac · Marshall, TXBuilt 1965 · S/N 320D0035 N4138TLindquist Holdings LLC · Noblesville, INBuilt 1965 · S/N 320D0038 N413DGWindsock Capital LLC · Bertram, TXBuilt 1959 · S/N 35814 N413WWWilkinson Jason S · Eastvale, CABuilt 1972 · S/N 340-0176 N4140QJohnson Kyle A · Cheshire, CTBuilt 1968 · S/N 310N-0040 N4141ALady Bird Of Rhinebeck LLC · Rhinebeck, NYBuilt 1978 · S/N 310R1374 N4144Q470 Corp · White Lake, MIBuilt 1968 · S/N 310N-0044 N4148QRomeo Carmen J · Beaver, PABuilt 1968 · S/N 310N-0048 N4149QMustain Michael J · Monticello, GABuilt 1968 · S/N 310N-0049 N414ACBirman Pablo · Suamico, WIBuilt 1975 · S/N 414-0820 N414AFSano Aviation Corp · Lewes, DEBuilt 1971 · S/N 414-0167 N414APLiving Word Ministries Inc · Shreveport, LAS/N 414-0512 N414AQQualitair LLC Trustee · MichelstadtBuilt 1974 · S/N 414-0472 N414ARFlight Med LLC · Cumming, GABuilt 1976 · S/N 4140902 N414AWAlycone Trust Corp Trustee · Wichita, KSS/N 4140520 N414BAOptimal Health Systems LLC · Pima, AZBuilt 1970 · S/N 414-0047 N414BDBostater Charles Jr · Indn Hbr Bch, FLBuilt 1973 · S/N 414-0430 N414BMBorden John · Raleigh, NCBuilt 1974 · S/N 414-0532 N414CDRepinter (Delaware) Inc · Coral Gables, FLBuilt 1972 · S/N 414-0357 N414CELocaero Services Inc Trustee · Wilmington, DEBuilt 1976 · S/N 414-0904 N414CRAga Aviation LLC · Woodruff, SCBuilt 1975 · S/N 414-0629 N414CTHollywood Aviation Investments LLC · Hollywood, SCBuilt 1971 · S/N 414-0256 N414DBNerwelah Holdings LLC · Martinez, GABuilt 1974 · S/N 414-0507

Back to AD 76-08-02 R2