Registered aircraft · 3,960

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.

N18BKShandog Air LLC · Ashland, KYS/N 310R0981 N18DLBelov Mikhail · Greenwood Village, COBuilt 1977 · S/N 310R1251 N18EGBoanco Inc · Lafayette, INBuilt 1973 · S/N 414-0394 N18MRMorey Airplane Co Inc · Middleton, WIBuilt 1978 · S/N 340A0557 N18SGBennett Jeannette DBA · Joiner, ARBuilt 1975 · S/N 310R0560 N18TN18t Ltd · Wilmington, DEBuilt 1968 · S/N 421-0144 N18TCAviotti Inc · Henderson, NVBuilt 1978 · S/N 421C0503 N18VUVincennes University · Vincennes, INBuilt 1977 · S/N 310R0928 N1905B605 Aviation LLC · Aberdeen, SDBuilt 1978 · S/N 414A0214 N1905ERusso Louis A Jr · Houston, TXBuilt 1979 · S/N 340A0664 N1908GAir Z Flying Service Inc · Richmond Heights, OHBuilt 1974 · S/N 310R0055 N1915WPasha Mohammad A · Muscatine, IABuilt 1971 · S/N 310Q0429 N1918EGuano Air LLC · Palmetto Bay, FLBuilt 1979 · S/N 340A0668 N1918JCoastal Satellite Inc · Woodland Hills, CABuilt 1976 · S/N 310R0703 N1919JValiair Lc Trustee · Casper, WYBuilt 1979 · S/N 310R1554 N1919LSmith Sydney O · Lithonia, GAS/N 411-0157 N1919VHigh Mountain Properties LLC · Idaho Falls, IDBuilt 1984 · S/N T30300271 N191CTBessemer Plywood Corp · Bessemer, MIBuilt 1974 · S/N 310R0057 N1920EHappy Trails Flight Training & Charters LLC · Helena, MTBuilt 1979 · S/N 340A0669 N1925GEfi Technology Inc · Cave Creek, AZBuilt 1975 · S/N 421B0826 N192AFWarren E Mack LLC · Minneapolis, MNBuilt 1980 · S/N 414A0496 N193DC310 Charter LLC · Zanesville, OHBuilt 1980 · S/N 310R1885 N1942GBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 421B0842 N1944EHans Construction LLC · Lititz, PAS/N 340A0675 N1944GBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 421B0844 N1946GPartwin421 LLC · Greenwich, CTBuilt 1974 · S/N 421B0846 N196CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0116 N196FSTechnical Education Services Inc · Virginia Beach, VABuilt 1978 · S/N 421C0501 N196TCClements Dylan A · Burlington, WIBuilt 1980 · S/N 310R1801 N197DB310 Flyers LLC · Lafayette, LAS/N 310R1809 N1987GPhillips Michael M · Angleton, TXBuilt 1974 · S/N 414-0544 N1995GHarris Justin R · Hico, TXBuilt 1974 · S/N 414-0602 N19AFBegley Edward R · Glasgow, KYBuilt 1966 · S/N 310K0100 N19DBDcs Air LLC · Pulaski, WIBuilt 1972 · S/N 310Q0668 N19DJLewis Landon Jon · Hope, NDBuilt 1977 · S/N 310R0868 N19LFN19lf Corp · Oak Lawn, ILBuilt 1972 · S/N 310Q0622 N19STS&S Aviation Co · Ball Ground, GAS/N 414A0452 N1GQAero Attack Systems (USA) Inc · Blaine, WANon-citizen corporation, flight hours not reportedBuilt 1972 · S/N 421B0236 N1QMAhlhorn Travis W · New Braunfels, TXBuilt 1979 · S/N 421C0701 N1YASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1974 · S/N 421B0580 N1YCMay Thomas W · Texarkana, TXBuilt 1976 · S/N 310R0621 N2002PGregory Edward · Council Bluffs, IABuilt 1979 · S/N 335-0022 N200BNRubber Duck Aviation LLC · Brunswick, GABuilt 1980 · S/N 421C0881 N200DCBjg Aviation I LLC · Neelyville, MOBuilt 1981 · S/N 421C1223 N200GCDancy Abram P · Shrewsbury, MABuilt 1978 · S/N 340A0503 N200MCN200mc Inc Trustee · Cheyenne, WYBuilt 1973 · S/N 414-0424 N200SHHoward Steve · Jefferson City, MOBuilt 1979 · S/N 310R1601 N200TNI & V Aviation LLC · Missoula, MTBuilt 1978 · S/N 421C0444 N200YCShady Aero LLC · Anchorage, KYS/N 340A0285 N20162Wateractive43 LLC · Auburn, CABuilt 1974 · S/N 310Q-1004

Back to AD 87-21-02 R1