Skip to content

Registered aircraft · 40,394

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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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.

N84ZRomeo Aviation Ltd · East Sparta, OHBuilt 1959 · S/N TD-232 N85007Sidell Joel R · Brighton, COBuilt 2010 · S/N 2000 N8500DScootair LLC · Alburgh, VTBuilt 1957 · S/N 22-5727 N8501DStrausser Brian J · Lower Burrell, PABuilt 1957 · S/N 22-5728 N8502DConrad Dylan · Randolph, WIBuilt 1957 · S/N 22-5729 N8503EB&B Aviation Holdings LLC · Pembroke Pines, FLBuilt 1976 · S/N 28-7690175 N8505DRegistration Pending · Wilmington, DERegistration pendingBuilt 1957 · S/N 22-5732 N8507DFischer Duane A · New Baden, ILBuilt 1957 · S/N 22-5734 N8508DHuhndorf Joshua L · Port Ludlow, WABuilt 1957 · S/N 22-5735 N8509DVeal Petra I · Sterling, AKBuilt 1957 · S/N 22-5736 N8510DShipley Steven D · Masterson, TXBuilt 1957 · S/N 22-5737 N8511FMrd Aero LLC · Manheim, PABuilt 1976 · S/N 28-7725119 N8513DRowland Nathan A · Lascassas, TNBuilt 1957 · S/N 22-5740 N8514DBecker Gloria J Personal Representative · Gladwin, MIBuilt 1957 · S/N 22-5741 N8514YMcnally Rodney · Sonora, CABuilt 1967 · S/N 30-1675 N8516DBass Edward L · San Angelo, TXBuilt 1957 · S/N 22-5743 N8516FFarley Gail A · Elizabethtown, PABuilt 1976 · S/N 28-7715276 N8517KBeadle Scott · Fort Worth, TXBuilt 1983 · S/N 1 N8518CBoesl Shawn W · Aberdeen, SDBuilt 1953 · S/N 20-993 N8518DWood Michael · Port Saint Lucie, FLBuilt 1957 · S/N 22-5745 N8518WEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1984 · S/N 0425 N8519YAerial Sign North Inc · Lakewood, NJBuilt 1970 · S/N 18-8885 N851DFFoster Gregory S · Woodstock, GABuilt 1975 · S/N AA5B-0149 N851LW578 Airplane Leasing Inc · Kissimmee, FLBuilt 1968 · S/N 17257189 N851NDSkymates Inc · Wilmington, DEBuilt 1989 · S/N 4495005 N851WTFowler Clinton Lewis · Conroe, TXBuilt 1976 · S/N 28-7790077 N8521YVan Devere Joseph C · Akron, OHBuilt 1970 · S/N 18-8886 N8522DAdams Daryl S · Monticello, FLBuilt 1957 · S/N 22-5750 N8524DBig Bend Community College Foundation · Moses Lake, WABuilt 1957 · S/N 22-5752 N8524YGasmire David C · Fredericksburg, TXS/N 18-8888 N8526Core Tech Services & Supply LLC · Odessa, FLBuilt 1973 · S/N 449-73 N8526FMinton Gabriel D · Wexford, PABuilt 1976 · S/N 28-7715279 N8526KBaratta Richard J · Tower, MNBuilt 1956 · S/N 18-4953 N8526ZRyther John W · Austin, MNBuilt 1952 · S/N 20-900 N8528CJain Abhishek · Weehawken, NJBuilt 1976 · S/N 28-7615115 N8528YYoung David A · Lakeland, FLBuilt 1968 · S/N 30-1689 N852DAHendrix Rex · Pell City, ALBuilt 1975 · S/N 17264427 N852HHoffart Paige D · Omaha, NEBuilt 2011 · S/N 81985 N852NDPlane Nonsense Inc · Middletown, DEBuilt 1989 · S/N 4495006 N852TStudarus John E · Sacramento, CABuilt 1974 · S/N M-1528 N8530DCurcio Steve J · Oak Creek, WIBuilt 1957 · S/N 22-5758 N8536DAnderson Kel G · Alta, IABuilt 1957 · S/N 22-5768 N8536YEastern Flight Services Inc · Ronkonkoma, NYBuilt 1984 · S/N 0438 N8537Kopaska Linda · Guthrie Center, IABuilt 1973 · S/N 452-73 N8538DMarble Jere D · Dayton, NVBuilt 1957 · S/N 22-5769 N8539DEdens Ferlin C · Boone, COBuilt 1957 · S/N 22-5770 N853AKKase Gayle L · Wasilla, AKBuilt 2017 · S/N 6901 N853RSOlson Helicopters LLC · Corpus Christi, TXS/N 3807 N8541CHulsey Johnathan James · Wasilla, AKBuilt 1997 · S/N 999 N8541EFlying Services Inc · Wilmington, DEBuilt 1984 · S/N 0442

Back to AD 79-10-03 R2