Skip to content

Registered aircraft · 54,019

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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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.

N2306RRenshaw Laurence A · Cave Creek, AZBuilt 1964 · S/N 18255406 N2306YEagle Sky Patrol Inc · Deadwood, SDS/N 17700106 N2307General Aviation Support Corp · Rosamond, CAS/N 17274920 N23070Building Busters Demolition & Excavation Corp · Saint Louis, MOBuilt 1968 · S/N 15068711 N23076Alvarado Victor A · Douglas, AZBuilt 1968 · S/N 15068714 N23078Pureflight Aviation Training LLC · Newberg, ORBuilt 1974 · S/N 17264080 N2307DSunderland Paul · Savannah, GAS/N 20459 N2307FEads Kevin · Arley, ALBuilt 1964 · S/N 21058507 N2307RSugiono Oliver C · San Marino, CABuilt 1964 · S/N 18255407 N2307UCowgar Jeremy N · Norton, OHBuilt 1962 · S/N 17249907 N2307XCornwall Brady Evan M · Shelton, WABuilt 1965 · S/N 18256207 N23083Gilstrap Stanley C · Inola, OKBuilt 1968 · S/N 15068717 N23085Flightwave 77 LLC · Dearborn Heights, MIBuilt 1968 · S/N 15068719 N2308EPavco Inc · Gig Harbor, WABuilt 1978 · S/N 17271228 N2308UMarsh Hank K · Joseph, UTBuilt 1956 · S/N 29528 N2308YAltman Richard A · Albuquerque, NMBuilt 1967 · S/N 17700108 N23096Pilot Pros Inc · Miami, FLBuilt 1968 · S/N 15068722 N23098Saddler Darrell L · Elk City, OKS/N 15068723 N2309GEquipment & Machinery Appraisal LLC · Grand Junction, COBuilt 1958 · S/N 51609 N230BLafitte John B · Villa Rica, GABuilt 1966 · S/N U206-0625 N230MAviation Developers Inc · Highlandville, MOBuilt 1984 · S/N U20606834 N230MMLackey Matthew Allen · Peachtree City, GABuilt 1980 · S/N R18201529 N230PLudian Malgorzata · Bakersfield, CABuilt 1967 · S/N T210-0279 N230RVEast Tennessee Aviation LLC · Mountain City, TNBuilt 1973 · S/N 17261598 N230SVSwailes Craig · Taylor, MIBuilt 1979 · S/N 152-83257 N23106Spencer Standlee B · Mineola, TXBuilt 1968 · S/N 15068728 N2310RMccarty Brian Keith · Huntsville, TXBuilt 1964 · S/N 18255410 N2310SWest Alabama Aircraft Leasing Inc · Tuscaloosa, ALS/N 337-0610 N2310UTec Aviation LLC · Euclid, OHBuilt 1962 · S/N 17249910 N23111G Force Advantage LLC · Lewes, DEBuilt 1968 · S/N 15068731 N23112Philp Robert J · Lysite, WYS/N 15068732 N23114Page Audra L · Shutesbury, MAS/N 15068734 N23117Cessna 23117 Aviation Services LLC · Colorado Springs, COS/N 15068736 N2311CB & B Aviation LLC · Wayzata, MNBuilt 1953 · S/N 30611 N2311DTwombly Eric D · Halfway, ORBuilt 1952 · S/N 20463 N2311FPace Seth M · Malibu, CABuilt 1964 · S/N 21058511 N2311GVan Winkle Randy M · Van Buren, MOBuilt 1959 · S/N 51611 N2311UDcy Flyers Inc · Montgomery, INBuilt 1962 · S/N 17249911 N23123Gafford Brian A · Lewis Center, OHBuilt 1968 · S/N 15068739 N23125Maldonado Cesar O · Utuado, PRFirst renewal noticeBuilt 1968 · S/N 15068740 N23128Keeny Kenneth K · Stewartstown, PABuilt 1968 · S/N 15068742 N2312FButler Scotty · Yukon, OKBuilt 1964 · S/N 21058512 N2312REagy Gregory L · Boise, IDBuilt 1964 · S/N 18255412 N2312XCain James W · Big Rapids, MIBuilt 1965 · S/N 18256212 N23133Gill Robert S · Woodinville, WABuilt 1968 · S/N 15068746 N2313RBlackman David M Trustee · Pacifica, CABuilt 1964 · S/N 18255413 N2313UNobles Homer L III · Sandy Valley, NVS/N 17249913 N23144Henry Ronald E · Sullivan, OHBuilt 1968 · S/N 15068751 N23148Blunt Christopher G · Chippewa Falls, WIBuilt 1968 · S/N 15068754 N2314EAirgo Inc · Centralia, ILBuilt 1978 · S/N 17271230

Back to AD 87-20-03 R2