Skip to content

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.

N8014MCaldwell Machine & Gear Inc · Mount Pleasant, TXBuilt 1964 · S/N 310I0014 N8015MGill Conrad D · Mounds, OKBuilt 1964 · S/N 310I0015 N802HLAir Hammer LLC · Wilmington, DES/N 414A0820 N802MCRunaway Plane LLC · Oklahoma City, OKBuilt 1980 · S/N 335-0044 N8030MInternational Air Services Inc Trustee · Carson City, NVBuilt 1964 · S/N 310I0030 N8034QGoins Plastic Source Inc · Texarkana, ARBuilt 1973 · S/N 310Q0691 N8036MObreiter Robert W Jr · Simi Valley, CABuilt 1964 · S/N 310I0036 N8047MVertigo Aviation Inc · Lighthouse Point, FLBuilt 1964 · S/N 310I0047 N8047QAir Boys Inc · Hayward, WIBuilt 1970 · S/N 421B0047 N8050MPrice Earl · Audubon, PABuilt 1964 · S/N 310I0050 N8055MHuffman Jacob M III · Burleson, TXBuilt 1964 · S/N 310I0055 N8056MHooper David M Trustee · South Jordan, UTBuilt 1964 · S/N 310I0056 N805PRValiair Lc Trustee · Casper, WYBuilt 1985 · S/N 414A1206 N8060MBata Michael R · Port Orange, FLS/N 310I0060 N8068QCreative Consulting Partners LLC · Fargo, NDBuilt 1974 · S/N 414-0503 N8071MLand Sea And Air Inc · North Mankato, MNS/N 310I0071 N8072MHigh Speed Flight Associates · Nickerson, KSS/N 310I0072 N8073MRussell David L · Wasilla, AKS/N 310I0073 N807WSInter Island Freight LLC · Deerfield Beach, FLBuilt 1968 · S/N 4010300 N8081MHawk Hangars Corporation LLC · Jenks, OKS/N 310I0081 N8083MUpshaw John L Jr · Claude, TXBuilt 1964 · S/N 310I0083 N8085QWes Hughes Corp · Waldron, KSBuilt 1974 · S/N 414-0506 N8086MCaudell Michael A · Cleveland, GABuilt 1964 · S/N 310I0086 N808BVFlying Dutchman LLC · Waipahu, HIBuilt 1975 · S/N 421C0004 N808TWVa Office Of Emergency Service LLC · Hampton, VABuilt 1977 · S/N 340A0304 N8091QKhag Aviation Inc · Woodbridge, NJFirst renewal noticeBuilt 1973 · S/N 402B0369 N8093QRobey Sean C · Camden, NCBuilt 1973 · S/N 421B0544 N8097MNovember Sierra Aviation LLC · Oneill, NES/N 310I0097 N809RQSouth Aero Inc · Albuquerque, NMBuilt 1981 · S/N 404-0809 N80BSSonrise Aviation LLC · Portland, INBuilt 1977 · S/N 404-0048 N80FADma One LLC · Dayton, OHBuilt 1977 · S/N 310R0985 N80JJZing Aviation And Marine LLC · New Smyrna, FLFirst renewal noticeS/N 414A0412 N80KRegistration Pending · Sparks, NVRegistration pendingBuilt 1963 · S/N 310H0098 N80LGTru North Aviation LLC · Ironwood, MIBuilt 1975 · S/N 421C0021 N80PVRamos Investments Lp · Montgomery, TXBuilt 1977 · S/N 414-0963 N80RSRoberson Mark E · Milton, FLBuilt 1975 · S/N 421B0895 N8103MCunningham Michael J · Great Falls, MTBuilt 1964 · S/N 310I0103 N8109MRegistered aircraftBuilt 1964 · S/N 310I0109 N810BWHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0279 N810SLidman Kirby · Ames, IABuilt 1964 · S/N 320B0062 N8112MFiedler Allen J · Imperial, PABuilt 1964 · S/N 310I0112 N8113MLansing Community College · Mason, MIBuilt 1964 · S/N 310I0113 N8116MJacobs Levon Jr · Oak Hill, FLBuilt 1964 · S/N 310I0116 N8118MRider Scott M · Beaverton, ORBuilt 1964 · S/N 310I0118 N811NAsplundh Eric P · Bryn Athyn, PAFirst renewal noticeBuilt 1978 · S/N 310R1317 N811NATm Aero LLC · Riverview, FLS/N 421C-1082 N811PGH&S Aircraft LLC · Lewes, DEBuilt 1984 · S/N 421C1413 N8122MNo Slack Flyers LLC · Klamath Falls, ORFirst renewal noticeBuilt 1964 · S/N 310I0122 N8125FMaglaughlin Ronald D · Udall, KSFirst renewal noticeS/N 402-0231 N8129QJolly Tyler S · Grover, COS/N 414-0029

Back to AD 87-21-02 R1