OpenAirDocs.org
AD 94-20-04 R2

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
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.

N9859RM20 Flying Club LLC · Kansas City, MOBuilt 1960 · S/N D-6406N985QMcdonald Mark R · Laguna Beach, CAFirst renewal noticeBuilt 1961 · S/N D-6847N9861RRichards Tyler B · Henderson, TXBuilt 1960 · S/N D-6408N9862RIsr Aviation LLC · Wilmington, DES/N D-6409N9865RBeyers Gary L · Temple, TXBuilt 1960 · S/N D-6414N9867RMoyer Thomas L · Fayetteville, GABuilt 1960 · S/N D-6446N9868RClark William T · Spartanburg, SCBuilt 1960 · S/N D-6421N9870RHoward Flying Service Inc · Clarksdale, MSBuilt 1960 · S/N D-6424N9874RDouglas Donald G · Park Rapids, MNBuilt 1960 · S/N D-6428N9875RPalmer Neal J · West Monroe, LABuilt 1960 · S/N D-6429N9876RValla Jospeh P · Santa Clarita, CABuilt 1960 · S/N D-6431N9879RSamuels Marty · Russellville, ARBuilt 1960 · S/N D-6459N9881RNowak Christopher G · Douglassville, PABuilt 1960 · S/N D-6439N9882RN9882r LLC · Punta Gorda, FLBuilt 1960 · S/N D-6448N988VTT & C Aviation LLC · Wilmington, DEBuilt 1959 · S/N D-6179N9891RPerazzo Enterprises Inc · Brookeland, TXBuilt 1960 · S/N D-6443N9892RSchultz Jason G · Crowley, LABuilt 1960 · S/N D-6441N9893RSaunders Christopher D · Lehighton, PABuilt 1960 · S/N D-6456N9895RMrd Aero LLC · Manheim, PAS/N D-6455N9897RStreetman W S · Rescue, CABuilt 1960 · S/N D-6463N9899RAspen Aircraft LLC · Oklahoma City, OKS/N D-6632N98BCOrr Daniel G · Greenfield, INBuilt 1963 · S/N D-7144N98GMMoore Gregory B · Granbury, TXBuilt 1961 · S/N D-6628N98LKMb Duncan Inc · Bakersfield, CABuilt 1977 · S/N D-10027N98MRAviato LLC · Heath, TXBuilt 1978 · S/N D-10119N98PSSchuessler Scott · Stillwater, OKBuilt 1977 · S/N D-9996N9905DDemarzo Alexander J · Flower Mound, TXBuilt 1959 · S/N D-5810N990MDMelchiorre Joseph G · Lewes, DEBuilt 1964 · S/N D-7527N990QRoswarski Ted A · Tempe, AZBuilt 1961 · S/N D-6856N9922RHeer Gregory D · Upland, CAFirst renewal noticeBuilt 1960 · S/N D-6495N992QRovelo Torres Jorge Federico · Boerne, TXBuilt 1961 · S/N D-6839N9936RMarshall Robert M · Dresden, OHBuilt 1960 · S/N D-6490N993QTangen Arthur · Albuquerque, NMBuilt 1961 · S/N D-6873N993TBeyond Approach LLC · Brighton, COBuilt 1964 · S/N D-7414N994QLooney Hubert · Florissant, MOBuilt 1961 · S/N D-6817N994RFFlagg Randall P · Southwick, MABuilt 1959 · S/N D-6017N994SGardner Adam P · Morrisville, NCBuilt 1957 · S/N D5180N995FMHalcyon Vineyards LLC · Sonoita, AZS/N D-5477N995QMetzger Jordan · San Diego, CABuilt 1961 · S/N D-6816N9972RMerfeld Thomas J · Clive, IABuilt 1960 · S/N D-6485N997BBBlankenship John R · Weirsdale, FLBuilt 1980 · S/N D-10328N997BC997bc LLC · Roseburg, ORS/N D-7761N998LTBfh Management LLC · Fernandina Beach, FLBuilt 1960 · S/N D-6293N99910Roof Management Ltd · Marysville, OHBuilt 1975 · S/N D-9767N99914Roof Management Ltd · Marysville, OHBuilt 1970 · S/N D-9178N9993Pro Team Aviation LLC · Jonesboro, ARBuilt 1970 · S/N D-9175N9994RPower Shane M · Parker, COS/N D-6480N9996RMitchell Myron · Advance, NCBuilt 1960 · S/N D-6483N999BBGoode Stephen C · Canton, TXS/N D-5630N999BCCcc Aviation LLC · Havre, MTBuilt 1965 · S/N D-7836
Back to AD 94-20-04 R2