Registered aircraft · 3,961

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-21-02-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:87-21-02-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:87-21-02-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:87-21-02-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:87-21-02-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:87-21-02-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.

N721VGB & W Aerial Spray Inc · Dimmitt, TXS/N 421B0847 N721YGRunway Aviation Flight Training USA Corp · Rockwall, TXBuilt 1974 · S/N 340-0342 N723ESEs Owens LLC · Mustang, OKBuilt 1982 · S/N 421C1217 N726LAValiair Lc Trustee · Casper, WYBuilt 1974 · S/N 421B0651 N726RTCrotts Aircraft Service Inc · Dodge City, KSBuilt 1976 · S/N 421C0087 N727ESHoover421 LLC · Rockport, TXBuilt 1977 · S/N 421C0268 N728CTBerns Ridge Service LLC · Whittier, CABuilt 1982 · S/N 340A1533 N728FRRoyal Air Freight Inc · Waterford, MIBuilt 1977 · S/N 310R1248 N728SCQuist David Andrew · Lake Jackson, TXS/N 310Q0989 N72JAOtter Air LLC · Fishers, INBuilt 1979 · S/N 414A0333 N72KGM & P Aviation LLC · Byhalia, MSBuilt 1980 · S/N 414A0513 N72VTNot Enuf LLC · Jackson, WYBuilt 1979 · S/N 340A0654 N730AFB Fam LLC · Texico, NMBuilt 1976 · S/N 414-0853 N7316UDarvek LLC · Las Vegas, NVBuilt 1965 · S/N 411-0016 N737MASipes Gary C · Livingston, TXS/N 310N-0093 N73EPColburn & Associates LLC · Woodruff, SCBuilt 1973 · S/N 340-0240 N73HMTrn Aviation LLC · Lewes, DES/N 421C0234 N73TBMagic Leasing LLC · Peotone, ILBuilt 1981 · S/N 414A0474 N740AGStefenelli Aviation N-Tr Inc Trustee · AtterseeS/N 421A-0033 N740CAHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0277 N740WJAlm Holding LLC · Winton, CABuilt 1979 · S/N 340A0740 N741DFSeeding Operations And Atmospheric Res (Soar) LLC · San Angelo, TXBuilt 1975 · S/N 414-0633 N744BWDobson'S Leasing Co LLC · Ocoee, FLBuilt 1981 · S/N 414A0658 N744CAMay Richard Ullmann · Soquel, CAS/N 421C1014 N745CARegistration Pending · Dover, DERegistration pendingS/N 421C1043 N745EPSumner Michael · Hahira, GABuilt 1974 · S/N 414-0498 N747CAAction Air Express Inc · Santa Monica, CAS/N 421C0850 N747RMJones Roy F · Benson, AZBuilt 1960 · S/N 39097 N747WSHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0080 N747YKYk Flight Inc Trustee · Wilmington, DEBuilt 1975 · S/N 310R0138 N748CADesert Air Ambulance Inc · Menifee, CABuilt 1980 · S/N 421C0905 N748MGEl Paso Aero Inc · El Paso, TXBuilt 1974 · S/N T310Q1128 N749CABig Bear Resorts Inc · Big Bear Lake, CAS/N 421C1239 N749SDewitt Scott · Corpus Christi, TXBuilt 1964 · S/N 320C0016 N74HJRegistration Pending · Sheridan, WYRegistration pendingBuilt 1974 · S/N 340-0333 N74PBBaranko Peter A · Meridian, IDBuilt 1981 · S/N 414A0828 N7505QJohnson Michael L · Jefferson, TXBuilt 1969 · S/N 310Q0005 N7508QZulu Hours LLC · Moneta, VABuilt 1969 · S/N 310Q0008 N750DRLukowski Zachary L · Gainesville, FLBuilt 1975 · S/N 310R-0064 N750PCMarilyn Merlot LLC · Kalispell, MTBuilt 1972 · S/N 340-0189 N7510QOne Zero Q LLC · Mount Pleasant, MIBuilt 1969 · S/N 310Q0010 N7512QGorge Winds Aviation Inc · Fairview, ORBuilt 1969 · S/N 310Q0012 N7516QS Flight LLC · Evergreen, COBuilt 1972 · S/N 310Q0530 N7517QQuay Ventures LLC · Alto, TXBuilt 1969 · S/N 310Q0017 N751CAHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0217 N7525QBuckin Donald L · Phoenix, AZS/N 310Q0025 N7526QWhat A Day To Travel LLC · Edgerton, WIS/N 310Q0026 N7530QBas Part Sales LLC · Greeley, COBuilt 1970 · S/N 310Q0030 N7531QSantiago Jose G Jr · Woodstock, GABuilt 1969 · S/N 310Q0031 N7537QRegistration Pending · Defiance, OHRegistration pending, pending cancellationBuilt 1970 · S/N 310Q0037

Back to AD 87-21-02 R1