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.

N3315EBas Part Sales LLC · Greeley, COS/N 17271501 N3315MRegistered aircraftAssigned, pending cancellationS/N 12-2159 N3315TLovelady William K · Grapevine, TXBuilt 1967 · S/N 17700615 N3316Wilson Robert L · Greenfield, OHBuilt 1970 · S/N 278 N33161Fca Flight Training LLC · Washington C H, OHS/N 28-7525165 N33162Plane Fun Inc Tr Trustee · Snellville, GABuilt 1943 · S/N 75-2783 N33169Good James R H · Nevada City, CABuilt 1975 · S/N 28-7515326 N3316MHickey Aero Services LLC · White Hills, AZS/N 12-2169 N3316PCrew Sourcing Inc · Wilmington, DEBuilt 1958 · S/N 23-1267 N33170Atlanta Sky Signs LLC · Sharpsburg, GABuilt 1975 · S/N 28-7505129 N3317MJacobs Robert E · Santa Fe, NMBuilt 1947 · S/N 12-2172 N3317TGay Don A DBA · Garfield, GABuilt 1967 · S/N 17700617 N33180Van Wagner Aerial Media LLC · Hollywood, FLS/N 5-456 N3318BDeane Daniel G · Park City, UTBuilt 1954 · S/N 22-2133 N3318ERodriguez Jose R · Los Angeles, CABuilt 1978 · S/N 17271502 N3318MMh Aviation LLC · Foster City, CAFirst renewal noticeBuilt 1947 · S/N 12-2176 N3318TPipeair LLC · Vancouver, WABuilt 1967 · S/N 17700618 N33195Heathco Merle S · Scappoose, ORBuilt 1976 · S/N 177RG0918 N3319AThomas Brian D · Corning, IABuilt 1953 · S/N 22-1595 N3319MWhirley Bradley J · Brainerd, MNBuilt 1947 · S/N 12-1883 N331BEBabich Leslie Paige · Lutz, FLBuilt 1981 · S/N M-2300 N331BGCavorite Aviation LLC · West Jordan, UTBuilt 2000 · S/N 2843373 N331CDDay Charles L · Edison, NJBuilt 1999 · S/N 333 N331CMCard Donald J · Dallas, TXBuilt 1999 · S/N 1 N331DHEaves Donald Ray · Byhalia, MSFirst renewal noticeBuilt 2000 · S/N 21754 N331DWHaehnel Patrick J · Elbert, COBuilt 2001 · S/N 001 N331FBurton Charles E · Jackson, CABuilt 2001 · S/N 5703 N331GPDodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N 44-7995277 N331GTPope Kent M · Hayden, IDBuilt 1984 · S/N 331 N331GZN331gz LLC · Fort Myers, FLBuilt 1980 · S/N WA-116 N331HTTope Loren C · Cody, WYBuilt 1989 · S/N HT-1 N331JBBostik Josef J · Green Cove Springs, FLBuilt 2002 · S/N 25108 N331MDMedmission Supplies LLC · Escondido, CABuilt 2018 · S/N 90991 N331MEHarrison Matthew T · Naponee, NEBuilt 2000 · S/N 172S8464 N331MKStardust Aviation LLC · Farmingdale, NYBuilt 2001 · S/N 2843477 N331NTCrowley E Ned · Londonderry, NHS/N N.C.1 N331PAHale Enterprises Inc · Carbondale, ILBuilt 2002 · S/N 2843514 N331RDHiggins Roland · Solon Springs, WIBuilt 2005 · S/N 25720 N331RPRaritan Valley Flying School · Princeton, NJS/N 172S9863 N331SYTorii Aviation LLC · Naperville, ILBuilt 1980 · S/N 7 N331TShimkus Stanley M · N Huntingdon, PABuilt 1953 · S/N 18-2445 N331VNYokosawa Kenneth Eino · Grand Blanc, MIBuilt 1982 · S/N 21 N331VRRoof Jerry G · Centennial, COBuilt 1991 · S/N 509 N331WTillman Nickolas R · Piggott, ARBuilt 1972 · S/N 287225543 N331WBAb Aviation LLC · Ashland, OHBuilt 1969 · S/N 28-5401 N3320MFena Daniel J · Side Lake, MNBuilt 1947 · S/N 12-2177 N3320ZHolton Mark · Lebanon, MOBuilt 1960 · S/N 22-7255 N33212Burlingame Lloyd · Fort Atkinson, WIBuilt 1976 · S/N 177RG0920 N3321BLee Donald R · Talkeetna, AKS/N 22-2136 N3321LN3321l LLC · Dacula, GAS/N 3321

Back to AD 90-04-06 R1