Registered aircraft · 18,497

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:86-13-04-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3') 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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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:86-13-04-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
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.

N331CBN331cb LLC · Great Falls, MTBuilt 1979 · S/N 21063747 N331EBEberly Mark H · Carmel, INBuilt 1976 · S/N CE-651 N331JTJuliet Tango Flying Services LLC · Walnut Creek, CABuilt 1972 · S/N 18501899 N331RHWhite Wing Aviation LLC · Shreveport, LABuilt 1977 · S/N CE-691 N33216Avarts LLC · New Castle, DES/N U20602676 N3321CAviation Management II LLC · Des Moines, IAS/N E-1261 N3321MMaxray Aviation LLC · Ashland, OHBuilt 1978 · S/N 310R1343 N3322XAllgood Michael K · Saint Augustine, FLBuilt 1974 · S/N 310Q1030 N33247R House Leasing LLC · Stormville, NYBuilt 1975 · S/N U20602692 N3325QWinrick LLC · Flagstaff, AZS/N 320D0125 N33277Niebuhr Bradley A · Morriston, FLS/N U20602708 N3327SDavis Blake A · Bellevue, TXS/N 21059127 N3329VMcmahon Jeffrey J · Paris, KYFirst renewal noticeBuilt 1947 · S/N D-790 N332CBFlying Pigs Aviation LLC · Los Altos, CABuilt 2000 · S/N E-3306 N332CDDuggar Aviation LLC · Springdale, ARBuilt 2004 · S/N 0873 N332DGRaymond Jeffrey R · Fairbanks, AKBuilt 1976 · S/N 18503043 N332HPDolan Charles A · Augusta, GABuilt 1990 · S/N CE1508 N332LMLumbra Ronnie E · Rye, NYBuilt 2005 · S/N 1332 N3330MMaine Instrument Flight · Augusta, MEBuilt 1979 · S/N TH-1031 N3332BAirkrapf LLC · Clearwater, FLBuilt 1997 · S/N E-3140 N3332SFluckey Gary T · Homer, AKS/N 18502274 N3333MFun Tickets LLC · Manchester, MEBuilt 1981 · S/N 340A1229 N3336SVancil Todd · Justin, TXBuilt 1969 · S/N 21059136 N3337Chay James M · Kent, WABuilt 1978 · S/N P3370316 N3337SBeery Bruce M · Lakeland, FLBuilt 1969 · S/N 21059137 N333AMLally Glen Joseph · Pleasanton, CABuilt 1975 · S/N 414-0651 N333ARLe Bon Air Inc Trustee · Wilmington, DEBuilt 2004 · S/N 0844 N333BCMcfadden John L · Cresson, TXBuilt 1977 · S/N 21061848 N333BENtn3n LLC · Titusville, FLBuilt 1960 · S/N 500A-979-33 N333BGWendt Brian R · Naples, FLBuilt 1981 · S/N 18504224 N333CJDrj Aviation LLC · Dover, DEBuilt 1972 · S/N 421B0313 N333DAFavor Michael D · Chico, CABuilt 1976 · S/N 21061289 N333DGAlligood Allen K · Wasilla, AKBuilt 1976 · S/N 18503234 N333FUIntricate Bay Operating LLC · Iliamna, AKBuilt 1977 · S/N U20604126 N333GKCenturion210 LLC · Amherst, NHBuilt 1976 · S/N 21061282 N333HRWilson Alan E Trustee · Erie, COBuilt 1974 · S/N 21060412 N333JPSpeece Ryan J · Vero Beach, FLBuilt 1967 · S/N D-8539 N333JWPhillips John Patrick · Cumming, GABuilt 1975 · S/N 21061094 N333KWD G R Air LLC · Braselton, GABuilt 1974 · S/N 421B0657 N333LB333lb LLC · Fort Worth, TXBuilt 1978 · S/N 21062890 N333LHKoelbl Aviation LLC · Whitesboro, TXBuilt 1981 · S/N 21064220 N333LJJarrell Christopher · Lincolnton, NCBuilt 1969 · S/N D-8969 N333PSDoran Jeffrey T · Westerville, OHS/N 21060834 N333PWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1980 · S/N 414A0525 N333REM I Aviation Inc · Juda, WIBuilt 1980 · S/N E-1737 N333RFQualitair Lc Trustee · MichelstadtBuilt 1976 · S/N TJ-92 N333RJAddco Aviation Services Inc · Newcastle, OKBuilt 1978 · S/N D10188 N333SFFerretti James L III · Port Orange, FLBuilt 1967 · S/N 411-0260 N333SJDonald Robert Ferguson · Billings, MTBuilt 1974 · S/N 18502614 N333SRRocky Mountain High Aviation LLC · Boulder, COBuilt 1977 · S/N TJ-114

Back to AD 86-13-04 R3