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.

N467DMMustang Sally Aviation LLC · Camden, SCBuilt 1973 · S/N 421B0377 N468KWLance Johnson Ministries Inc · Calhoun, GABuilt 1962 · S/N 310G0058 N46941Haynes Aviation LLC · Caruthersville, MOS/N 35495 N469LCGaletti Ralph R · Albuquerque, NMBuilt 1974 · S/N 421B0627 N469TMAerostream Services LLC · Cincinnati, OHS/N 310K-0202 N46CGGlobal Building Investments Inc · Scottsdale, AZS/N 310P0146 N46RKAir Positive LLC · Selbyville, DEBuilt 1969 · S/N 310P0122 N470BCCorvus Flight LLC · Salinas, CABuilt 1977 · S/N 414-0918 N471HBMyers Ralph E · San Clemente, CABuilt 1977 · S/N 414-0923 N473SLuginbuhl Wayne E · Ormond Beach, FLBuilt 1966 · S/N 310K0131 N474DBMr Restore Services Inc · Vero Beach, FLBuilt 1976 · S/N 310R0822 N474DLPrasad Sanjeev K · Las Vegas, NVBuilt 1976 · S/N 310R0704 N475JNMiller Aviation LLC · Carrier Mills, ILS/N 414-0917 N4763GGamma Transport Solutions Inc · Carrollton, TXFirst renewal noticeBuilt 1977 · S/N 414-0938 N4765GAircraft Charter And Leasing LLC · El Cerrito, CABuilt 1977 · S/N 414-0940 N477MGJuliet Delta Aviation LLC · Bozeman, MTBuilt 1973 · S/N 421B0477 N4795GAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 414-0949 N4798CKjv Aviation Inc · Brentwood, CAS/N 414-0012 N47AGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1972 · S/N 340-0114 N47BGVonweisenstein Thomas W · Brentwood, TNBuilt 1974 · S/N 310Q1061 N47DSHalls Dave · Lilburn, GABuilt 1959 · S/N 39005 N47MDBrambles Inc · Bakersfield, CABuilt 1977 · S/N 414-0945 N47NFAndrews University · Berrien Springs, MIS/N 60-6047 N47RWSale Reported · Glen Allen, VASale reportedS/N 35088 N47SPDurham Rex L · Blakely, GABuilt 1969 · S/N 310P0176 N4800B310 LLC · Auburn, WABuilt 1955 · S/N 35100 N480BWAttitude Aviators Inc · North Myrtle Beach, SCBuilt 1967 · S/N 310L-0137 N4811BLifland Kenneth D · Mckinney, TXBuilt 1955 · S/N 35111 N4815BCochise Community College · Douglas, AZBuilt 1955 · S/N 35115 N483JFKg Aviation LLC · Huntington, WVBuilt 1974 · S/N 414-0537 N4844BPrevost Christopher D · Sonoma, CAS/N 35144 N4863BBeach Travis W · Bishop, CABuilt 1955 · S/N 35163 N4868AKlokner James B · Madison, WIBuilt 1978 · S/N 310R1393 N4877BHardman Kyle B · Shady Shores, TXBuilt 1955 · S/N 35177 N4884BPrevost Christopher · Sonoma, CABuilt 1955 · S/N 35184 N488SSale Reported · Friday Harbor, WASale reported, pending cancellationS/N 4140529 N488SJDeans Casing Service Inc · Holdenville, OKFirst renewal noticeBuilt 1977 · S/N 414-0959 N488SPSugarpop Air LLC · Chicago, ILBuilt 1967 · S/N 310N-0029 N4891BLiberty School Of Aviation Inc · Miami, FLRevoked, canceledBuilt 1955 · S/N 35191 N48BPRossman Richard J DBA · Glenview, ILBuilt 1975 · S/N 421B0957 N4905AAnderson Ryan Alexander · Minnetrista, MNBuilt 1978 · S/N 310R1397 N490KMRasf414 LLC · Hallandale Beach, FLS/N 414-0399 N4927AGenx Aviation LLC · Leesburg, VABuilt 1978 · S/N 310R1504 N4937JSwirsding David J · Chalfont, PABuilt 1977 · S/N 310R0952 N4938AK E R Air LLC · Fort Myers, FLBuilt 1978 · S/N 310R1406 N4941AMartinello Domenic · Clarksville, TNBuilt 1978 · S/N 310R1407 N4948AKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1978 · S/N 310R1410 N4949ASw Air LLC · Denver, COS/N 310R1505 N494WKingsbury Raymond S · Farmington, MNS/N 310K0103 N497JMBazzi Aviation LLC · Newark, DEBuilt 1972 · S/N 310Q0497

Back to AD 76-08-02 R2