Skip to content

Registered aircraft · 54,017

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.

N341FCCondor Aero Club Inc · Zelienople, PABuilt 1978 · S/N 17270371 N341JCCopeland David Craig · Jackson, GABuilt 1978 · S/N R18200577 N341PBPpb Aviation Management · Wading River, NYBuilt 1971 · S/N 17701661 N341RG341rg LLC · Little Rock, ARBuilt 1977 · S/N 177RG1155 N341RMRocky Mountain Skydive LLC · La Salle, COBuilt 1966 · S/N 18256826 N34202Srs Aurora LLC · Saint Germain, WIBuilt 1972 · S/N 17701700 N34205Dingman Douglas W · Albuquerque, NMBuilt 1976 · S/N 177RG0982 N34206Jason Air Inc · Arlington, TNBuilt 1972 · S/N 17701704 N34208Hokie Flying Club Inc · Christiansburg, VABuilt 1976 · S/N 177RG0983 N34209Friesen Chevrolet Inc · Sutton, NEBuilt 1972 · S/N 17701707 N3420RBietz Jason L · Tripp, SDBuilt 1967 · S/N 18258720 N3421CPalouse Pilot Training LLC · Spokane, WABuilt 1954 · S/N 26464 N3421DGultch Dale R · Brookfield, WIBuilt 1955 · S/N 26964 N3421EWisconsin Aviation Inc · Watertown, WIBuilt 1978 · S/N 17271539 N3421JOakley Lance · Haslet, TXS/N 15066121 N3421USchuster Timothy A · Carrington, NDBuilt 1963 · S/N 18254821 N3421VNebbia Valter Della · Archer City, TXBuilt 1974 · S/N 15076498 N3421YMarshall Air LLC · Paso Robles, CABuilt 1979 · S/N R18201420 N3422Hergenrather Michael · Spring, TXS/N U20602920 N34221Baxter Jonathan · Centerville, MABuilt 1976 · S/N 177RG0985 N34223Strother Brenda J · Kenai, AKBuilt 1972 · S/N 17701715 N34225Dexter Paul J · Orange, MABuilt 1972 · S/N 17701717 N34226Blasjo Darrell W · Hesperia, CAS/N 177RG0986 N34227Neiser David R · Napavine, WABuilt 1972 · S/N 17701719 N34228Thomas Andrew J · Brownsburg, INBuilt 1972 · S/N 17701720 N34229Winchester Creek Aviation LLC · Waynesville, NCBuilt 1972 · S/N 17701721 N3422CEversoll Dennis D · Petersburg, INS/N 26465 N3422JRoberts Stephen L · Belmont, MIBuilt 1967 · S/N 15066122 N3422LAwsm Inc · Grand Canyon, AZBuilt 1967 · S/N U206-0722 N3422SLanders James F Jr · Mesa, AZBuilt 1964 · S/N 18255822 N3422TMangon Ronald A · Petaluma, CABuilt 1967 · S/N 17700722 N3422UK & M Aircraft LLC · Granbury, TXBuilt 1963 · S/N 18254822 N3422YMoll Kenneth R · Willow, AKS/N 18051922 N34231Anderson Roger Q · Manassas, VABuilt 1972 · S/N 17701723 N34232Nowacki James R · Brighton, MIBuilt 1972 · S/N 17701724 N34233Stimpson Shawn S · Blackfoot, IDS/N 17701725 N34235Nefc Inc · North Andover, MABuilt 1972 · S/N 17701726 N3423SSchroeder Matt T · Riverside, CABuilt 1964 · S/N 18255823 N3423TCardinal Aviation LLC · Springdale, ARBuilt 1967 · S/N 17700723 N34241Lewis Mark · Ellisville, MOS/N 17701728 N34242Cherokee Pilots LLC · Royersford, PABuilt 1972 · S/N 17701729 N34244Eliel F John · Sequim, WABuilt 1972 · S/N 17701731 N34248Lucia Arthur H · Blacksburg, VABuilt 1972 · S/N 17701732 N3424CHarris Wayne H · Altamont, TNBuilt 1972 · S/N 17701727 N3424JBaird Gary H · Bracey, VABuilt 1967 · S/N 15066124 N3424RMulder Field Inc · Ivanhoe, MNS/N 18258724 N3424SPickering Heavy Hauling · Fort Lupton, COBuilt 1964 · S/N 18255824 N3424TWiggains David · Canyon, TXBuilt 1968 · S/N 17700724 N3424VDriscoll Christopher · Beaufort, SCBuilt 1974 · S/N 15076499 N34250Sierra Lima Aviation LLC · Riverton, UTBuilt 1972 · S/N 17701734

Back to AD 87-20-03 R2