Registered aircraft · 6,916

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:71-13-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:71-13-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:71-13-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:71-13-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:71-13-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:71-13-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.

N3068THomeyer Joanne · Alexander, ARBuilt 1979 · S/N 32R-7987111 N3069TTop Tier Truck And Trailer LLC · Amarillo, TXS/N 32R-7987112 N306CSSecurity Alert Aviation LLC · Gilroy, CABuilt 2016 · S/N T20609225 N306YSFlamingo Aircraft Holdings LLC · Orlando, FLBuilt 2024 · S/N 4636850 N3071YHarrys Flying Circus LLC · Tampa, FLBuilt 2004 · S/N 3255018 N3075RPiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 32R-7987110 N307CSDetwiler Jeffrey D · Lancaster, PABuilt 2013 · S/N T20609105 N307RJGv Air Inc · Medford, ORBuilt 2012 · S/N T20609060 N30834Tribec Group International Inc · Medina, OHBuilt 2004 · S/N 3255019 N3088HDon Abney Inc · Patterson, LABuilt 2007 · S/N 3257465 N308AROverstreet Investments Inc · Boonville, MOBuilt 2024 · S/N T20609756 N308BEAlge Aviation Inc · Middletown, DES/N 32R-7780110 N308CLRodoni William · Santa Cruz, CABuilt 2008 · S/N T18208825 N308CPCivil Air Patrol · Maxwell Afb, ALBuilt 2014 · S/N T20609128 N308DMD&M Aircraft Co Inc · Thonotosassa, FLBuilt 2023 · S/N T20609745 N3092JJett-A Aviation LLC · Houston, TXBuilt 2008 · S/N 3257487 N3092SDavidson Robert I · Coeur D Alene, IDBuilt 2004 · S/N 3257366 N3093FChurchill Air LLC · Jamestown, NYBuilt 2004 · S/N 3246221 N30947Silver Palms Aviation LLC · Miami, FLBuilt 2004 · S/N 3257367 N3094RDrygala Marcin M · Williamsburg, VABuilt 2005 · S/N 3257388 N3094WSeneca Flight LLC · Gosnell, ARBuilt 2005 · S/N 3255038 N3095GLas Piedras LLC · Englewood, COBuilt 2008 · S/N 4692065 N3098HIcarus Be Damned LLC · Algonquin, ILBuilt 2007 · S/N 3257478 N3098NValiair Lc Trustee · Casper, WYBuilt 2004 · S/N 4636357 N3099ELustig Consulting LLC · Mount Pleasant, SCBuilt 2005 · S/N 3257382 N3099LJsn Aviation LLC · Ocala, FLBuilt 2005 · S/N 3255032 N309DKNby Productions · Bristow, VABuilt 2021 · S/N T20609643 N309HWWolfe Rentals LLC · Milwaukie, ORBuilt 2013 · S/N 4636612 N30CPSkyveris LLC · Simi Valley, CABuilt 1973 · S/N 27-7305022 N30DFDae Aviation Enterprises Corp · Gilford, NHBuilt 1974 · S/N 31-7401263 N30DRRuble Force One LLC · Wilkinson, INBuilt 1978 · S/N 31-7912006 N30SAMsm30sa LLC · Jericho, NYS/N 31-7952142 N30SCRegistration Pending · Wauchula, FLRegistration pendingBuilt 1981 · S/N 31-8152098 N30TPLe Ciel Bleu LLC · Hudson, WIBuilt 1981 · S/N 31-8152062 N310CMAir Positive LLC · Selbyville, DEBuilt 1969 · S/N 310P-0178 N310PGMid-South Bulk Services Inc · West Memphis, ARS/N 31-7512051 N31122Ross Jeremy · Lufkin, TXBuilt 2005 · S/N 3257394 N3114ATavallaee Mehran Monazam · Crossville, TNBuilt 2008 · S/N 3257490 N3117KDegatech Systems Inc · Van Nuys, CABuilt 2005 · S/N 3257398 N311KFAlpha Papa LLC · Fort Stockton, TXBuilt 1999 · S/N 4636194 N311LGCorporate Aviation Partners I LLC · Fort Worth, TXBuilt 2025 · S/N 4636866 N311TGTg Air LLC · Fishers, INBuilt 2021 · S/N T20609653 N3120ETandberg Kjell · Beverly Hills, FLBuilt 2005 · S/N 3257400 N3120TMcbride Matthew T · Eagle River, WIBuilt 2006 · S/N 3257417 N31222Dc Air LLC · Lebanon, MOBuilt 2004 · S/N 3257354 N3129BRaabe Craig A · West Hartford, CTBuilt 2006 · S/N 3257415 N312AKSafeco Leasing LLC · Port Alsworth, AKBuilt 1973 · S/N 31-7305015 N312CDMcwhorter Properties Graysville LLC · Anniston, ALBuilt 1980 · S/N 31-8052182 N312KKHowser Donald Marvin III · Granbury, TXBuilt 2004 · S/N T20608472 N3131MAir Service LLC · Wilmington, DEBuilt 2006 · S/N 4636382

Back to AD 71-13-01 R1