Registered aircraft · 54,017

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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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.

N337CGH&J Flight One LLC · Sun City West, AZBuilt 1973 · S/N P3370143 N337CHAviation Specialty Services LLC · Beaufort, NCBuilt 1977 · S/N 33701836 N337DTomalar Inc · Vero Beach, FLNon-citizen corporation, flight hours not reportedBuilt 1966 · S/N 337-0306 N337DEAirbermz LLC · Bloomfield Hills, MIBuilt 1980 · S/N 33701943 N337DMMcwhorter Michael S · Fortuna, CABuilt 1968 · S/N P206-0471 N337DWR And R Aircraft Inc · Delray Beach, FLBuilt 1975 · S/N 33701652 N337EEAmpaire Inc · Long Beach, CABuilt 1974 · S/N 33701600 N337EWWilson Cecil · Lithonia, GABuilt 1969 · S/N 337-1193 N337EXTrepanier Dennis A · Agua Dulce, CAS/N 33701737 N337FRomain Dennis · Payson, AZBuilt 1973 · S/N 33701547 N337FTMclenaghan Alvin N · Phoenix, AZBuilt 1966 · S/N 3370384 N337GDPorrima Photonix Inc · Las Cruces, NMBuilt 1979 · S/N 33701921 N337GFLewis John P · Alachua, FLBuilt 1969 · S/N 17258349 N337GGInterventional Cardiovascular Group Of San Juan In · Laredo, TXS/N 33701429 N337GRLor Aviation LLC · Atlanta, GABuilt 1969 · S/N 33701210 N337GSJc Holding LLC · Wilmington, DEBuilt 1973 · S/N 33701520 N337HBCessna 337 LLC · Wilmington, DES/N P3370293 N337JFBeaty Andrew R Jr · Wichita Falls, TXFirst renewal noticeBuilt 1966 · S/N 3370391 N337JJJodice Timothy · Amherst, NHBuilt 1972 · S/N P3370026 N337JLDavis Mike D · Huntersville, NCS/N 337-0708 N337JRInternational Air Services Inc Trustee · Carson City, NVS/N 33701474 N337JSI V S K LLC · Wilmington, DES/N 337-1136 N337KMAltamont Air LLC · Dublin, CAS/N P3370263 N337LASturgeon Kenneth V · Winter Garden, FLBuilt 1965 · S/N 337-0134 N337LFA To B Flying Inc · Litchfield, ILFirst renewal noticeBuilt 1969 · S/N 337-1057 N337LPSkymaster Stc LLC · Mena, ARBuilt 1977 · S/N 33701750 N337MMAugugliaro Robert J · Albuquerque, NMBuilt 1967 · S/N 337-0608 N337MWMtw Aerospace Inc · Montgomery, ALBuilt 1972 · S/N P3370021 N337NEAviation Specialty Services LLC · Beaufort, NCBuilt 1969 · S/N 337-0997 N337PHayes James J · San Diego, CAS/N 33701535 N337PCPhantom Technologies LLC · Garden City, IDBuilt 1980 · S/N 21064212 N337RTillman Tracy S · Webberville, MIBuilt 1977 · S/N P3370282 N337RCN337rc Corp Trustee · Wilmington, DEBuilt 1968 · S/N 337-1014 N337RDDamschroder Rex A · Fremont, OHBuilt 1968 · S/N 337-0847 N337RGStephens Kenneth Joe · Bristol, TNBuilt 1972 · S/N P3370067 N337RRLara Oscar · Bonita, CABuilt 1973 · S/N P3370116 N337RSDinwiddie Michael R · Sunbury, OHS/N P3370074 N337RTTorres Ramon A · Mulberry, FLBuilt 1965 · S/N 337-0089 N337RWRamey Chris M · Simpsonville, KYBuilt 1977 · S/N P3370295 N337SMFlippin Birds Aircraft LLC · Miami, FLS/N 3370495 N337SSState Of Wisconsin/Doa · Madison, WIBuilt 1976 · S/N 33701716 N337SVLillie Ronald G · Salt Lake City, UTS/N 337-0628 N337TGSafe & Sound LLC · Kalispell, MTBuilt 1979 · S/N P3370281 N337TKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1972 · S/N 33701462 N337TLInternational Air Services Inc Trustee · Carson City, NVS/N 33701418 N337TRDel Rio Aviation Inc · Paso Robles, CABuilt 1967 · S/N 337-0648 N337TSWalz Steve · Kiowa, KSBuilt 1966 · S/N 337-0300 N337TWRtw Aviation LLC · Tulsa, OKBuilt 1977 · S/N P3370299 N337TXBlue Skies Aviation Services LLC · Bynum, TXBuilt 1968 · S/N 337-0801 N337USkymaster Mods & Parts LLC · Castalian Springs, TNS/N P3370346

Back to AD 87-20-03 R2