Registered aircraft · 56,580

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

N32BEWisecup Wilbur V Jr · Germantown, OHBuilt 1974 · S/N 17263249 N32CHHeckler Gary C · Carefree, AZBuilt 1966 · S/N 18257332 N32CWMcdiarmid Jeffrey · Walla Walla, WABuilt 1977 · S/N 18265680 N32DBCarpenter Forrest A · Berthoud, COBuilt 1966 · S/N 18051714 N32EKTips Dan N · Plano, TXBuilt 1963 · S/N 18051264 N32FCZimin Transportation LLC · South Naknek, AKBuilt 1953 · S/N 30431 N32GVEastern Cincinnati Aviation Inc · Batavia, OHS/N 17267026 N32LACircle S Aviation LLC · Starkville, MSBuilt 1972 · S/N 17260454 N32LPBartlett Paul H · Nebo, NCBuilt 2025 · S/N 18283331 N32LTLt Leasing LLC · Saint Petersburg, FLBuilt 2021 · S/N 18283154 N32MCCook Tracy L · Prosper, TXBuilt 1974 · S/N 21060482 N32MPAshford Aviation Inc · Dothan, ALBuilt 1981 · S/N 172RG1019 N32PLDiette Paul S · Middlebury, VTBuilt 1980 · S/N 18267595 N32PXKustatan Leasing LLC · Kenai, AKBuilt 1976 · S/N U20603343 N32RLVb Glass Company Inc · Jamestown, CAS/N U20605551 N32TCarolina Blue Aviation LLC · Villanova, PABuilt 1978 · S/N 18266670 N32VACommonwealth Of Virginia · Richmond, VABuilt 1974 · S/N 182-63322 N32YAFlydreams Aircraft Group Inc · Fort Lauderdale, FLBuilt 1980 · S/N 17273862 N32ZZJp Lemke Aviation LLC · Jenison, MIBuilt 1977 · S/N 18265469 N3300AAdams Air & Sea Inc · Wilmington, DEBuilt 1969 · S/N 337-1094 N3300JIngram Jay Wallis · El Paso, TXBuilt 1966 · S/N 15066000 N3300YRaulston Electric LLC · Bagwell, TXBuilt 1962 · S/N 18254300 N3301DJohnson Peter L · Chico, CAS/N 32099 N3301RJuliet Zulu Holdings LLC · Dover, DEBuilt 1967 · S/N 18258601 N3301VErhard Robert T · Granville, OHBuilt 1974 · S/N 15076453 N3302JWignot Andrew R · Oceanside, CABuilt 1966 · S/N 15066002 N3302YFoster James R · Mcpherson, KSBuilt 1962 · S/N 18254302 N3303JWilliams Charles S · Pearland, TXBuilt 1967 · S/N 15066003 N3303YWoolery David W Jr DBA · Lathrop, MOBuilt 1962 · S/N 18254303 N3304FStephan Pamela K · Anchorage, AKBuilt 1966 · S/N 18257304 N3305RLivingston Sonja L · Redding, CABuilt 1967 · S/N 18258605 N3305YWolfe Randall S · Wasilla, AKBuilt 1962 · S/N 18254305 N3306DAlquist Kevin B · Edwardsville, KSBuilt 1955 · S/N 32104 N3306EBlackwell Calvin C · Fort Worth, TXBuilt 1978 · S/N 17271498 N3306JRound Engine Aero · Nashville, MIBuilt 1966 · S/N 15066006 N3306UMartin Paul R Jr · Greensboro, GABuilt 1963 · S/N 18254706 N3306YSaunders Craig · Spring Hill, FLBuilt 1962 · S/N 18254306 N3307RPhan Tam M · Charlotte, NCBuilt 1967 · S/N 18258607 N3307UPatronyk Gregory M · Santa Barbara, CABuilt 1963 · S/N 18254707 N3308FBravo Hotel LLC · Lewes, DES/N 18257308 N3308RLocatelli Gabriel G · North Bend, ORBuilt 1967 · S/N 18258608 N3308SSutton Aircraft Salvage LLC · Palmer, AKBuilt 1973 · S/N 18502267 N3309JMomentum Foundation · Tullahoma, TNS/N 15066009 N3309SCessna 210 N3309s LLC · Yellville, ARBuilt 1969 · S/N 21059109 N3309YRuschak Donald A · Charleroi, PABuilt 1962 · S/N 18254309 N330BDD & J Holdings LLC · Ellis, IDBuilt 1973 · S/N 18261634 N330CTRobinson Paul J · Saint Joseph, MOBuilt 1974 · S/N 17702158 N330FSkydive Wayland LLC · Melbourne, FLBuilt 1957 · S/N 34329 N330GBBrenner Gary L · Mission Viejo, CABuilt 1975 · S/N 18264242 N330JDGreen Erik M · Mastic Beach, NYBuilt 1998 · S/N 18280267

Back to AD 79-10-14 R1