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.

N8275UStout Kerrick L · New Richmond, OHFirst renewal noticeBuilt 1979 · S/N 18-7909102 N82765Musumeci Paul N · Wilmington, DEBuilt 1980 · S/N 28-8190062 N8276DMusko Richard · Plains, PABuilt 1958 · S/N TD-22 N8276ESkyview Aviation LLC · Tracy, CABuilt 1979 · S/N 17272163 N8276HDelalat Sean · San Diego, CABuilt 1980 · S/N 28-8116055 N8276JWiser Anthony J · Goodyear, AZBuilt 1979 · S/N VAC-122-79 N8276NShreffler Christine A · Ballwin, MOBuilt 1980 · S/N 28-8116056 N8276VNorthrop John B · Madison, WIBuilt 1980 · S/N 28-8190056 N8276WTreleven Alfred Herbert IV · Tacoma, WAS/N 28-2431 N8276XBnb LLC · Greenwich, CTBuilt 1980 · S/N 28-8190057 N8276ZPar Five Enterprises LLC · Columbus, OHBuilt 1980 · S/N 28-8190061 N82770O'Neil Chadwick P · Wells, MEBuilt 1975 · S/N 495 N82779Northeast Planes Aviation Inc · Laramie, WYBuilt 1980 · S/N 28-8190058 N82783Gulf Atlantic Airways Inc · Gainesville, FLBuilt 1980 · S/N 28-8116057 N8278EEquinoxx Flight Systems LLC · Lawrenceville, GABuilt 1979 · S/N 17272165 N8278NBastian Richard D · Chiloquin, ORBuilt 1969 · S/N 28-25493 N8278WChamberlain Mark S · Hamburg, NYBuilt 1965 · S/N 28-2434 N8279EHull Farms Inc · Blythe, CABuilt 1979 · S/N 17272166 N8279JRowland Blayne C Administrator · Raymondville, TXS/N VAC-125-79 N8279NWillson Michael S · Saint Cloud, FLBuilt 1969 · S/N 28-25495 N8279PRobinson Andrew T · South Windsor, CTS/N 1835 N827ATAviation Training LLC · Wilmington, DEBuilt 2002 · S/N 4496149 N827CTobin James M · Latrobe, PABuilt 2001 · S/N 81106 N827GBJohnson Douglas C · North Grafton, MABuilt 1998 · S/N 22394 N827GSFosha Kathryn · Tehachapi, CAS/N 23646 N827JHEisenmenger James P Trustee · Yankton, SDBuilt 1996 · S/N 2438 N827WTCsu Aviation LLC · Plainfield, INBuilt 1996 · S/N 1222-96 N8280NEllis Clifford J · Murray, KYBuilt 1969 · S/N 28-25496 N8280WGarbin Kurt A · Steamboat Springs, COBuilt 1965 · S/N 28-2437 N8281CThomas Ken C · Fairbanks, AKBuilt 1954 · S/N 18-3689 N8281JJudy Gregory K · Hudson Oaks, TXBuilt 1979 · S/N VAC-127-79 N8281NTan Dexter E · Dallas, TXS/N 28-25497 N8281WNeisen Brandon L · Fowler, ILBuilt 1965 · S/N 28-2438 N8282JHoover Michael B · Ridgeland, WIBuilt 1979 · S/N VAC-128-79 N8282VEnsemble Air LLC · Laramie, WYBuilt 1980 · S/N 28-8116060 N8282WBenker Albert J · Bevier, MOBuilt 1965 · S/N 28-2440 N82832Stokke Todd · Magnolia, TXBuilt 1980 · S/N 28-8190066 N82836Aerodreams Aviation LLC · Raleigh, NCBuilt 1980 · S/N 28-8190071 N8283JFurey Gale J · Bedford, NHBuilt 1979 · S/N VAC-129-79 N8283NRuth Joyce Aviation LLC · Henderson, TXBuilt 1969 · S/N 28-25499 N8283VMiloud Chadd K · Fort Worth, TXBuilt 1980 · S/N 28-8116065 N8283YPhillips Thaddus L · Knoxville, TNBuilt 1980 · S/N 28-8190064 N8284JCrouch Scott M · Steamboat Springs, COBuilt 1979 · S/N VAC-130-79 N8284NHolland Alan L · Houston, TXBuilt 1969 · S/N 28-25501 N8284WCaldwell Darrel R · Panama City Beach, FLBuilt 1965 · S/N 28-2443 N8285BHyldburg Aviation Inc · Plymouth, MABuilt 1980 · S/N 28-8116066 N8285EJames G Loy General Contractor Inc · Punta Gorda, FLBuilt 1979 · S/N 17272171 N8285WBas Part Sales LLC · Greeley, COBuilt 1965 · S/N 28-2446 N8285YAmerican Aviation Inc · Woods Cross, UTFirst renewal noticeBuilt 1980 · S/N 28-8190073 N82864Meyer Fredric Kim · Orange, CABuilt 1982 · S/N 28-8316005

Back to AD 79-10-03 R2