Skip to content

Registered aircraft · 20,481

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:84-10-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1') 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:84-10-01-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
  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:84-10-01-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
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.

N670JHNatural Resources Engineering Co Pa · Superior, WIFirst renewal noticeBuilt 1978 · S/N U20604489 N6710MFlying Skylanes Inc · Hillsborough, CABuilt 1975 · S/N 18263810 N6712RAero Applications Inc · Burley, IDBuilt 1966 · S/N T210-0112 N6713CClemens Jerry W · Benton, KSBuilt 1965 · S/N 18256662 N6714MIda Aviation LLC · Virginia Beach, VABuilt 1975 · S/N 18263812 N6715RRose Mary R · Portland, ORBuilt 1966 · S/N T210-0115 N671PMBarron Bradley C · Harper, TXBuilt 1979 · S/N 18267475 N6720RJacobsen Ian M · Lincoln City, ORBuilt 1966 · S/N T210-0120 N6722BJca Aviation LLC · Safford, AZS/N 21062826 N6722MLatham Scott W · Naples, FLBuilt 1975 · S/N 18263815 N67236Cessna N67236 LLC · Harrah, OKBuilt 1964 · S/N 18255666 N6724RDavis Lease LLC · Fort Collins, COBuilt 1966 · S/N T210-0124 N6727RChase Holden · Boulder, COS/N T210-0127 N6729RDfo Dynamic Aviation LLC · Glendale, AZBuilt 1966 · S/N T210-0129 N672CPCivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 18283238 N672DMWoodland Works Inc · Buena Vista, GABuilt 1977 · S/N 18265855 N673Henniker Flying Club Inc · Concord, NHBuilt 1974 · S/N 18263416 N6732ROregonian Flying Club · Wilmington, DEBuilt 1966 · S/N T210-0132 N6735MJenks John W · Marlton, NJBuilt 1977 · S/N 21061987 N6736MDehaan Aviation LLC · Bethel, AKBuilt 1975 · S/N 18263818 N6736RD Kevin Lester Md Inc · Fresno, CABuilt 1966 · S/N T210-0136 N6737RJpk LLC · Waterloo, NEBuilt 1966 · S/N T210-0137 N673ATCitizen Air LLC · Port Angeles, WABuilt 1976 · S/N U20603513 N673DKBh Aero LLC · Hanover, MNBuilt 1979 · S/N 21063479 N6743RBas Part Sales LLC · Greeley, COBuilt 1966 · S/N T210-0143 N6744WSouthwest Flying Club · The Woodlands, TXBuilt 2022 · S/N 18283181 N6745RHurt Todd A · Springfield, ORBuilt 1966 · S/N T210-0145 N6746RSchwartz Daniel T · Meeker, COBuilt 1966 · S/N T210-0146 N6749RPmbarrett Aviation LLC · Tucson, AZBuilt 1966 · S/N T210-0149 N674MPhillips Joseph H · Anchorage, AKBuilt 1959 · S/N 50437 N6750MHerrejon Rene · Willits, CABuilt 1975 · S/N 18263822 N6753RCooper Melvyn R Jr · Albany, GAFirst renewal noticeBuilt 1966 · S/N T210-0153 N6754RJarvis Ronald Louis · Gig Harbor, WABuilt 1966 · S/N T210-0154 N6755MFinch Bird Aviation LLC · Eagar, AZBuilt 1975 · S/N 18263824 N6757RRock Air LLC · Round Mountain, NVS/N T210-0157 N6759RRegistered aircraftS/N T210-0159 N675DFTextron Aviation Inc · Wichita, KSS/N 18283359 N6761RPerini Mark J · Greenleaf, IDBuilt 1966 · S/N T210-0161 N6764MKahuna Sky LLC · Howell, MIBuilt 1975 · S/N 18263828 N6768RTaylor Bradley K · Muskego, WIS/N 18280543 N6769RDomingues Silvio · Woodland, ALBuilt 1966 · S/N T210-0169 N676DCPrinc Aviation LLC · Beloit, KSBuilt 1972 · S/N 18261020 N6773MLake Erie Aviation LLC · Lyndhurst, OHBuilt 1975 · S/N 18263830 N6776MSchweitzer Laura L · Pullman, WABuilt 1975 · S/N 18263831 N6777RMarsh John E · Washington, DCS/N T210-0177 N6778MNikodem Daniel E · Lakeland, TNBuilt 1977 · S/N 21061990 N6779BRegistered aircraftBuilt 1978 · S/N 21062829 N677LSFry Justin T · Cincinnati, OHBuilt 1974 · S/N 18262634 N677RDWise Timothy L · Quinton, OKBuilt 1966 · S/N 18257090 N677YN677y Inc · Doylestown, PABuilt 1967 · S/N 18258374

Back to AD 84-10-01 R1