Registered aircraft · 68,375

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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.

N3291FEvans Derek M · Fresno, CABuilt 1967 · S/N 670384 N3292FGoodwin Darrell W · Richmond, TXBuilt 1967 · S/N 670385 N3292PCrosswindz Ranch LLC · Seminole, TXS/N 23-1242 N3292TCelestial Kinetics Flight Academy LLC · Waupaca, WIBuilt 1967 · S/N 17700592 N3292ZAlbertson James M · Westville, FLBuilt 1959 · S/N 18-7229 N32932Gilbert Roy S · Mechanicsville, VABuilt 1974 · S/N 28-7515276 N3293BHuttunen Alice D Trustee · Wasilla, AKBuilt 1954 · S/N 18-3287 N3293FYe Xiaofeng · Los Gatos, CABuilt 1968 · S/N 680001 N3293QRegistration Pending · Gainesville, TXRegistration pendingBuilt 1977 · S/N 28-7790447 N3293RBrook Jacob C · Broken Arrow, OKBuilt 1969 · S/N 28R-31264 N3293VMckinney Brian · Lakeville, MNBuilt 1995 · S/N 80 N3293ZStraight And Leve Aeromedical LLC · Billings, MTS/N 18-7230 N32942Bent James L Jr DBA · Palatine Bridge, NYS/N 18-7231 N32947Alpe Holding LLC · Van Nuys, CABuilt 1974 · S/N 28-7515279 N3294BSylvester Robin R · Soldotna, AKBuilt 1954 · S/N 18-3292 N3294CNorwood Kent L · Springfield, MOBuilt 2015 · S/N 90649 N3294FWatkins Grant M · Durant, OKBuilt 1967 · S/N 670387 N3294MLorenzo Jennifer A · Meridian, IDBuilt 1947 · S/N 12-2142 N3294RMurray Dennis P · Malta, NYBuilt 1969 · S/N 28R-31265 N3294TWolniansky Peter W · Ocean Grove, NJS/N 17700594 N3295MParamount Air Service · Rio Grande, NJBuilt 1947 · S/N 12-2143 N32966Tumbleson Shelly L · San Antonio, TXBuilt 1940 · S/N 5750 N32969Henry Robert K · Knoxville, TNBuilt 1974 · S/N 28-7515282 N32971Umbdenstock Jerry R · Thermopolis, WYBuilt 1974 · S/N 28-7505106 N32978Klippel Charlie L · Huntington Beach, CABuilt 1975 · S/N 28R-7535103 N3297BStevens Lance R · Kennewick, WAS/N 18-3299 N3297FCadillac Aircraft Services Inc · Cadillac, MIBuilt 1967 · S/N 670390 N3297TBurgdorf Dale A · Plano, TXBuilt 1967 · S/N 17700597 N32983Critz Sue Anne · El Paso, TXBuilt 1975 · S/N 28-7515283 N32988Blackman Jeremy Trustee · Memphis, TNBuilt 1974 · S/N 28-7515284 N3298PCross Albert B III · Salinas, CABuilt 1957 · S/N 23-1248 N3298T515 Aviation LLC · Dexter, IABuilt 1967 · S/N 17700598 N32990Trident Aircraft Leasing LLC · Easton, MDBuilt 1974 · S/N 28-7515285 N32993N32993 LLC · Provo, UTBuilt 1975 · S/N 28-7505108 N32994Lima Golf Bravo LLC · Chandler, AZBuilt 1975 · S/N 28R-7535104 N3299BWamberg Donald D · North Bend, NEBuilt 1954 · S/N 18-3302 N3299EBeglin Bruce W · Oxford, MDBuilt 1978 · S/N 17271495 N3299LHarrington David J · Albuquerque, NMBuilt 1967 · S/N 17256199 N3299MJorgensen Duwayne L · Effort, PAS/N 12-2146 N3299RDavis Charles · Sanford, FLBuilt 1970 · S/N 28R-31270 N3299TSale Reported · Daytona Beach, FLSale reported, canceledBuilt 1967 · S/N 17700599 N329ACDean Henry C · Texarkana, TXBuilt 2001 · S/N 425-2000 N329DJBritt Matthew W · Trenton, SCBuilt 1976 · S/N 177RG0845 N329EPetrocsko David Paul · Scottdale, PABuilt 1999 · S/N 8404-A-684 N329EDPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 2881991 N329FPNetwork Spares · Wilmington, DEBuilt 1969 · S/N 18-7421 N329GBN329gb LLC · Chattanooga, TNBuilt 1978 · S/N ME-45 N329JFJ F Aviation Inc · Joliet, ILBuilt 1975 · S/N 17265835 N329LTango Aviation Rentals LLC · Austin, TXBuilt 1967 · S/N 28-23574 N329MECentral Iowa Aviation LLC · Ankeny, IABuilt 2000 · S/N 172S8461

Back to AD 90-04-06 R1