Registered aircraft · 188

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-04-05') 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-04-05') 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-04-05')
    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-04-05')
  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-04-05')
  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-04-05')
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.

N116JJProgress Aviation LLC · Ellicott City, MDBuilt 1984 · S/N 421C1404 N1206NCapital Group Inc · Garden City, IDBuilt 1985 · S/N 421C1805 N124TMUniversal Aviation LLC · Decatur, ARS/N 421C-0898 N12RJDesert Air Ambulance Inc · Blythe, CABuilt 1977 · S/N 421C0306 N13HLFreedom 421b LLC · Jacksonville, FLBuilt 1975 · S/N 421B0927 N13PGJohnston Steven P · Coto De Caza, CABuilt 1976 · S/N 421C0031 N1421MClausen Johan Robert · Las Vegas, NVBuilt 1976 · S/N 421C0106 N144MLLewis University · Romeoville, ILBuilt 2000 · S/N LIV-149 N146TJBirdboys2 Aviation LLC · Boerne, TXBuilt 1978 · S/N 421C0500 N1510GGmr Leasing LLC · Lincoln, DEBuilt 1974 · S/N 421B0606 N160DCPdii LLC · Concord, NCBuilt 1980 · S/N 421C0856 N188GWBrown Die Casting & Manufacturing Inc · Royse City, TXBuilt 1979 · S/N 421C0613 N18TN18t Ltd · Wilmington, DEBuilt 1968 · S/N 421-0144 N1QMAhlhorn Travis W · New Braunfels, TXBuilt 1979 · S/N 421C0701 N200BNRubber Duck Aviation LLC · Brunswick, GABuilt 1980 · S/N 421C0881 N210GMStipe Leslie Wayne · Mcalester, OKBuilt 1976 · S/N 21061393 N214CCSteele Aviation LLC · Tuscaloosa, ALS/N 421C0670 N21SGTwo One Sierra Golf LLC · Seattle, WABuilt 1976 · S/N 421C0039 N21SSMidwest Corporate Air Inc · Bellefontaine, OHBuilt 1978 · S/N 421C0473 N228JHBuzzed Landing LLC · Ocean Springs, MSBuilt 1980 · S/N 421C-1006 N234MDMurphy David F · Amsterdam, NYBuilt 1958 · S/N 58-12093 N23RLCaljet Inc · Van Nuys, CABuilt 1981 · S/N 421C1094 N241TSGrey Matter Inc · Valley Springs, CAS/N 421B0110 N260RAUpward Aviation LLC · Tulsa, OKBuilt 1980 · S/N 421C1004 N264DCAirdvm LLC · Rcho Sta Marg, CABuilt 1982 · S/N 421C1248 N2657NLoreto Aviation LLC · Wahoo, NES/N 421C0811 N26588Golden Aero LLC · Tarpon Springs, FLBuilt 1980 · S/N 421C0835 N2660UUnited Front Holdings LLC · Laguna Hills, CABuilt 1981 · S/N 421C1210 N284DMDreamworks Aviation LLC · Palm Beach Gardens, FLBuilt 1984 · S/N 421C1406 N287TASivad Holdings Corp · Nacogdoches, TXBuilt 2025 · S/N 087/US N28RHNational Airplane Sales & Leasing Corp · Lima, OHBuilt 1980 · S/N 421C0847 N2957QGenerals International Inc · Red Oak, TXBuilt 1969 · S/N 421A0057 N299GBHoodoo LLC · Missoula, MTBuilt 1980 · S/N 421C1031 N311CASouthern Wings LLC · Shreveport, LABuilt 1977 · S/N 421C0252 N311JHHuaco Aviation LLC · Waco, TXBuilt 1980 · S/N 421C0814 N315MDuckwing LLC · Reno, NVS/N 421B0107 N31KSPaxton Jacob · Killeen, TXS/N 421B-0662 N321HASkytook LLC · Wilmington, DEBuilt 1973 · S/N 421B0420 N342RCHyland'S Pharmacy LLC · Wheeler, TXBuilt 1982 · S/N 421C-1243 N344TCInternational Air Services Inc Trustee · Carson City, NVS/N 421C0424 N355RTBeechwood Aviation LLC · Wilmington, DEBuilt 1974 · S/N 421B0633 N369RMRothschild Jonathan Trustee · Tucson, AZBuilt 1976 · S/N 421C0071 N375KCGuittard Chocolate Holdings Co · Burlingame, CABuilt 1982 · S/N 421C1226 N37JKSsr LLC · Incline Village, NVS/N 421B0934 N37RZOwens Martin · Telluride, COBuilt 1979 · S/N 421C0823 N388BCAerospace Trust Management LLC · Wilmington, DEBuilt 1975 · S/N D-9786 N3920CN3920c Lc · Wichita, KSBuilt 1976 · S/N 421C0145 N404NEFehlhaber Wolfgang M · Port Orange, FLBuilt 1981 · S/N 404-0857 N40MEUnlimited Boat Sales Inc · Page, AZS/N 421C1241 N40RUMoore Terry Alexander Trustee · Adel, GABuilt 1980 · S/N 421C0878

Back to AD 87-04-05