Registered aircraft · 4,469

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

N5875JMiller Michael Andrew · Huffman, TXBuilt 1965 · S/N D-7868 N5876J76juliet Aviation LLC · Firth, NES/N D-7869 N5876SDevine Steven A · Roseville, CABuilt 1965 · S/N D-7822 N5877SNguyen Tri Ngoc · Fort Worth, TXBuilt 1965 · S/N D-7758 N5878JThomas William S · Casa Grande, AZBuilt 1965 · S/N D-7870 N5879CSkeen Nikki B · Redlands, CABuilt 1951 · S/N D-2835 N587LBlech Connor N · Chowchilla, CABuilt 1959 · S/N D-6239 N5881JDj&M Aero LLC · Eau Claire, WIBuilt 1965 · S/N D-7871 N5883JFaire Kenneth D · La Canada, CABuilt 1965 · S/N D-7874 N5887SMcmartin Cutler J · Roanoke, TXBuilt 1965 · S/N D-7760 N5888TWendt Oliver James Jr · Adrian, MIBuilt 1963 · S/N D-7295 N5889CHoye Charlie L · Rimrock, AZBuilt 1957 · S/N D-2840 N5890CHumphrey Gary L · Lake Havasu City, AZBuilt 1951 · S/N D-2842 N5890JBengal Lawrence W · Upland, CABuilt 1965 · S/N D-7877 N5892CPeter Jesse D · Glendive, MTBuilt 1951 · S/N D-2844 N5894SV Tail Therapy LLC · Seattle, WABuilt 1965 · S/N D-7765 N5895SBurson Lloyd R · Anthony, NMBuilt 1965 · S/N D-7773 N5896CVeal Thomas H · Cocoa Beach, FLS/N D-2849 N5896SPreston Robert J · Pittstown, NJBuilt 1965 · S/N D-7826 N5897SPrecision Aviation LLC · Califon, NJBuilt 1965 · S/N D-7828 N5899JSchuyler Paul E · Morgan Hill, CABuilt 1965 · S/N D-7880 N5899SNvl Properties LLC · Wilmington, DEBuilt 1965 · S/N D-7769 N58BZMacaluso Robert T Trustee · Livingston, TXBuilt 1958 · S/N D-5423 N58CYBenson Eric A · Beulah, COBuilt 1953 · S/N D-3524 N58EJKavalecs Stephen A · Beaver Meadows, PABuilt 1958 · S/N D5458 N58KWBloomer Carl A · Bull Valley, ILBuilt 1958 · S/N D-5690 N58PTBarsukov Kirill · Jersey City, NJBuilt 1968 · S/N D-8855 N58VTPhilippou Thomas C · Harvard, MABuilt 1958 · S/N D-5446 N5900CKaufmann Landry V · Gamaliel, KYBuilt 1951 · S/N D-2854 N5901SSheffield Kraig · Guthrie, OKBuilt 1966 · S/N D-8118 N5902SFuhrmann Roy R · Webster, MNBuilt 1966 · S/N D-8110 N5903CCollins John P · El Cajon, CAS/N D-3273 N5905SLutes Ralph E · Shipshewana, INBuilt 1966 · S/N D-8130 N5907CN5907c LLC · Fairhope, ALBuilt 1952 · S/N D-3290 N5908CAircorps Aviation LLC · Bemidji, MNBuilt 1952 · S/N D-3267 N590PMMcewen Drew M · Wichita, KSBuilt 1969 · S/N D-8909 N5910SCrow River Aviation LLC · Watertown, MNBuilt 1966 · S/N D-8122 N5912CLindley Shawn P · Boone, COBuilt 1953 · S/N D-3414 N5912STop Hand Field Service LLC · Stillwater, OKBuilt 1968 · S/N D-8830 N5915SFord Keith A · Colorado Springs, COBuilt 1966 · S/N D-8120 N5916SCross Gerald S · Fresno, CABuilt 1966 · S/N D-8124 N5917CVierra David R · Chaska, MNBuilt 1952 · S/N D-3277 N5920SLukan Duane G Trustee · Liberty Lake, WAS/N D-8131 N5921CRegistered aircraftS/N D-3281 N5924CJuneau Greg L · Shreveport, LAS/N D-3283 N5925CBrickey William C · Morrilton, ARBuilt 1952 · S/N D-3284 N5926CCase Robert M · Poulsbo, WABuilt 1952 · S/N D-3285 N5928CF3f LLC · Bountiful, UTBuilt 1952 · S/N D-3288 N5929SPalmer Wade D · Adair, OKBuilt 1966 · S/N D-8137 N592SMStewart Robert D · Strasburg, COBuilt 1973 · S/N D-9563

Back to AD 94-20-04 R2