Skip to content

Registered aircraft · 2,553

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.

N6767TAviation Career Enrichment Inc · Atlanta, GABuilt 1960 · S/N 39067 N676MFCoastal Resource Associates Inc · Christiansted, VIBuilt 1971 · S/N 402B0106 N6772XKallhoff Mark R DBA · Canby, MNBuilt 1961 · S/N 310-0072 N6777MPineiro Enrique · Miami, FLBuilt 1961 · S/N 310-0073 N6779TDoyle Mary · Hampton, IABuilt 1960 · S/N 39079 N6779XSmith Peter I Trustee · Ocala, FLBuilt 1961 · S/N 310-0079 N677HCWashburn Wall Systems LLC · Cedar Rapids, IAS/N 421B0387 N6780XN6780x LLC · Duluth, MNBuilt 1961 · S/N 310-0080 N6784XSjc Vii LLC · Lawrence, KSBuilt 1961 · S/N 310-0084 N6787XTennis Gayland L · Bath, MIBuilt 1961 · S/N 310-0087 N678DBGolden Eagle Flight LLC · Farmington, UTBuilt 1975 · S/N 421B0876 N6791XEve Scott G · Odessa, TXBuilt 1961 · S/N 310-0091 N6792T2a Emergency Site Services LLC · Swainsboro, GABuilt 1960 · S/N 39092 N6797XJ & W Air LLC · Wilmington, DEBuilt 1961 · S/N 310-0097 N67CMSmith Kenneth L · Pomona, CABuilt 1973 · S/N 310Q0977 N67MLBgdr LLC · Wilmington, DEBuilt 1975 · S/N 340-0519 N67RKRiley Matthew · Xenia, OHS/N 310Q1107 N6817TErickson Paul M · Okahumpka, FLS/N 39117 N6821TCollard George E · Bountiful, UTBuilt 1960 · S/N 39121 N6823TSpaulding Rod D · Atascadero, CABuilt 1960 · S/N 39123 N6824TDoc'S Flight Training LLC · Prescott, AZBuilt 1960 · S/N 39124 N6826TPetecraft Aviation Services Inc · Plains, GABuilt 1960 · S/N 39126 N6827TLordemann Eric P · Petersburg, NES/N 39127 N6830LN661w Air LLC · Dalton, GABuilt 1980 · S/N 310R2102 N68310Redcell Air Inc · Miami, FLBuilt 1979 · S/N 310R1614 N6832YPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1980 · S/N 310R2121 N6833LBentley Timothy · Richmond, KYBuilt 1981 · S/N 310R2125 N6833TBartek Ronald T · Lake Charles, LABuilt 1981 · S/N 310R2128 N6838XOcean Flight Corp · Weston, FLBuilt 1978 · S/N 402B1346 N685CPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 310R-1375 N6877TBeedy Lyle G · Derby, KSBuilt 1960 · S/N 39177 N688SPSanchez Eddy B · Miami Gardens, FLS/N 402B0603 N688WGDebritton Daniel R · Tustin, CABuilt 1957 · S/N 35613 N6893TJurn Paul · Sandusky, MIBuilt 1960 · S/N 39193 N6898TMoore Albert Jr · Indianapolis, INBuilt 1960 · S/N 39198 N689DCSirek David G · Fritch, TXBuilt 1960 · S/N 39068 N68EAerometal International Inc · Aurora, ORS/N 35383 N68RDWilliams Gerald L · Malibu, CABuilt 1965 · S/N 320D0026 N68WAChuss Edward J · Metamora, MIBuilt 1968 · S/N 421-0137 N6906TReid Brian M · Boise, IDBuilt 1960 · S/N 39206 N6910LN6910l LLC · Yucca Valley, CABuilt 1966 · S/N 310K0010 N6914LC2 Holdings 22 LLC · Chesapeake, VABuilt 1965 · S/N 310K0014 N6919LJohnson Alan D · Prior Lake, MNBuilt 1965 · S/N 310K0019 N6920LGlen Air Inc · Powder Springs, GAS/N 310K0020 N6922LMontana Air Service · Big Timber, MTBuilt 1965 · S/N 310K0022 N6927TVawter William R Jr · Fort Worth, TXBuilt 1960 · S/N 39227 N6928TWhite Christopher G · Lynchburg, VABuilt 1960 · S/N 39228 N6929LCochran Aviation Inc · Haslet, TXBuilt 1966 · S/N 310K0029 N6929TWestrum Sean R · Norwalk, IAFirst renewal noticeBuilt 1960 · S/N 39229 N6933TCarl Jeffrey E · Wyoming, NYBuilt 1960 · S/N 39233

Back to AD 76-08-02 R2