Skip to content

Registered aircraft · 40,471

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:80-04-03-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:80-04-03-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:80-04-03-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:80-04-03-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:80-04-03-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:80-04-03-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.

N7832VBaker Benjamin D · Catasauqua, PAS/N 2935 N7832WRankin Kevin J · Maryville, MOBuilt 1964 · S/N 28-1849 N78330Wings Over Texas Holdings LLC · Denton, TXBuilt 1968 · S/N 17257567 N78331Clifton Jack D · La Junta, COS/N 17257568 N78332Albright John T · Decatur, ALBuilt 1968 · S/N 17257569 N78335Marotte David J · Windham, NHBuilt 1968 · S/N 17257570 N78338Mbh Aviation LLC · Tulalip, WABuilt 1968 · S/N 17257572 N78339Hopfmann Alwin E · Rutland, MABuilt 1968 · S/N 17257573 N7833GOrlandi Properties LLC · Blairstown, NJBuilt 1970 · S/N 17259533 N7833NStrait Brian C · Joplin, MOBuilt 1969 · S/N 28-5287 N7833WLukehart Steve D · Lincoln, NEBuilt 1964 · S/N 28-1850 N78341Davis Glenn A · Fair Oaks, CABuilt 1968 · S/N 17257575 N78349Raker Theodore B · Hahira, GABuilt 1968 · S/N 17257578 N7834GSmith Perry L · Brook Park, MNS/N 17259534 N7834NVector Aviation LLC · Mentor, OHBuilt 1969 · S/N 28-5288 N7834VMorris Tommy R · Houston, TXBuilt 1964 · S/N 2870 N7834WCleek Norris E · Orland, CABuilt 1964 · S/N 28-1851 N78351Caron John · Ellsworth, MIBuilt 1968 · S/N 17257579 N78354Tonar Richard J Jr · Omaha, NES/N 17257581 N78355Fleming Gary R · Wickliffe, KYBuilt 1968 · S/N 17257582 N78358All American Aviation LLC · Fort Worth, TXS/N 17257585 N78359Burns Stanley R · Flagler, COBuilt 1968 · S/N 17257586 N7835NOrrill Bill · Godfrey, ILBuilt 1969 · S/N 28-5289 N78367Dardis Barry J · Great Falls, MTBuilt 1968 · S/N 17257587 N7836NMelancon Scottie J · Baton Rouge, LABuilt 1969 · S/N 28-5291 N78371Lillace Kevan · Shelby, MTBuilt 1968 · S/N 17257590 N78375Bozeman Leasing Inc · Bozeman, MTS/N 17257593 N7837GGlass Jay Thomas · El Dorado, ARBuilt 1970 · S/N 17259537 N7837HCounsell Michael J · Moses Lake, WABuilt 1946 · S/N 12-737 N7837MDiamond B Farm Inc · Gamaliel, KYBuilt 1962 · S/N 2373 N7837WHock Matthew G · Culbertson, NEBuilt 1964 · S/N 28-1854 N78385Amf Aviation LLC · Dallas, GABuilt 1968 · S/N 17257595 N78388Fortner Weston · Fort Payne, ALBuilt 1968 · S/N 17257596 N7838NWright David P Jr · Chandler, AZBuilt 1969 · S/N 28-5293 N78395Fgds LLC · Louisville, KYBuilt 1968 · S/N 17257599 N7839DMartin David · Jackson, GABuilt 1957 · S/N 22-5489 N7839GGerty Air LLC · Sidney, MEBuilt 1970 · S/N 17259539 N7839NHaddle Eddie J · Lindon, UTBuilt 1969 · S/N 28-5295 N783AJApple Ronald L · Fort Myers, FLBuilt 1979 · S/N AA5B1093 N783BWestside Air Inc Renton · Renton, WABuilt 1958 · S/N TD-55 N783DGJeffery & Weiss Holdings LLC · Long Beach, CABuilt 1980 · S/N 17274063 N783FMFmfa Inc · Wilmington, DEBuilt 1980 · S/N 17274259 N783LKPullis Troy K · Hutchinson, MNBuilt 1959 · S/N 22-6900 N783SHKmc Aircraft Leasing LLC · Spanish Fork, UTBuilt 2004 · S/N 3617 N78408On The Fly Aero LLC · Ocean City, NJBuilt 1968 · S/N 17257604 N7840DDavis Steven T · Colleyville, TXBuilt 1957 · S/N 22-5490 N7840FLederach David B · Bethlehem, PABuilt 1976 · S/N 28-7790228 N7840NBiby Steven R · Churchs Ferry, NDBuilt 1969 · S/N 28-5294 N7840WTomic Milos · Westminster, COBuilt 1964 · S/N 28-1857 N7840XShaw Christopher S · Porterville, CAFirst renewal noticeBuilt 1961 · S/N 48340

Back to AD 80-04-03 R2