Skip to content

Registered aircraft · 54,015

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.

N8440XMenozzi Elizabeth M · Eastsound, WABuilt 1961 · S/N 17248940 N84412Sohini Vinod Rai · Lufkin, TXBuilt 1969 · S/N 17258464 N8441JAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1967 · S/N 15066341 N8441LG1 Aviation LLC · Ocala, FLBuilt 1968 · S/N 17256641 N8441ZWingman Aviation LLC · Pella, IABuilt 1963 · S/N 205-0441 N84422Dhr Investments LLC · Beaumont, TXBuilt 1969 · S/N 17258467 N84429Avz Aviation Of Tennessee Inc · Knoxville, TNBuilt 1969 · S/N 17258468 N8442GFoster Dustin · Dublin, VAS/N 15062542 N8442QFerguson John W · Edwardsburg, MIBuilt 1976 · S/N U20603301 N8442XReady Aim Flyer LLC · New Castle, DEBuilt 1961 · S/N 17248942 N8442ZGrant Bo Allen · Lovell, WYBuilt 1963 · S/N 205-0442 N84434Russell Aerial Photography Inc · Edgewater, FLBuilt 1969 · S/N 17258469 N8443GVon Wald Enterprises LLC · Glendale, AZBuilt 1965 · S/N 15062543 N8443JThunderbolt Resourcing LLC · Warrensburg, MOBuilt 1967 · S/N 15066343 N8443UNapieralski Todd Allan · Chelsea, MIS/N 17252343 N8443ZMitchell Peter J · Concord, CABuilt 1963 · S/N 205-0443 N84440Yankee Charlie LLC · Melbourne, FLBuilt 1969 · S/N 17258472 N84449Eskridge Jonathan L · Rio Rancho, NMBuilt 1969 · S/N 17258475 N8444LRiley David R · Baltimore, MDBuilt 1968 · S/N 17256644 N8444MSlusher Michael E · Dufur, ORBuilt 1959 · S/N 52212 N8444TSlusher Thomas R · The Dalles, ORBuilt 1959 · S/N 52344 N8444ZBaugh Jeffery · Brigham City, UTBuilt 1963 · S/N 205-0444 N84455Green Castle Aero Club · Oxford, IABuilt 1969 · S/N 17258476 N84456Warbirds East Inc · Fairhope, ALBuilt 1969 · S/N 17258477 N84459Maddox Glen E · Bushnell, FLBuilt 1969 · S/N 17258478 N8445LCurtis Bruce G · Eugene, ORBuilt 1968 · S/N 17256645 N8445TKoecher Wayne L · Cooper Landing, AKBuilt 1959 · S/N 52345 N8445ZSegerstrom William Clark · Sunriver, ORBuilt 1963 · S/N 205-0445 N84465Double Bridges Aviation LLC · Enterprise, ALBuilt 1969 · S/N 17258482 N84466Carrel Micah Dane · Paris, KYBuilt 1973 · S/N 18261868 N84468Whiting Joseph · Roy, UTBuilt 1969 · S/N 17258485 N8446JBent James L Jr DBA · Palatine Bridge, NYS/N 15066346 N8446QHarms Harvey D · Chugiak, AKBuilt 1978 · S/N 18503704 N8446SInfanger Jim Bob · Salmon, IDFirst renewal noticeBuilt 1965 · S/N 18256546 N8446TJones Russell V · Kernville, CABuilt 1959 · S/N 52346 N8446XSels Philip O · Magnolia, DEBuilt 1961 · S/N 17248946 N8446ZRegistration Pending · Liberty Lake, WARegistration pendingBuilt 1963 · S/N 205-0446 N84473Lawrence Blake C · Monument, ORBuilt 1969 · S/N 17258487 N8447SSteinheiser Terry N · Renfrew, PABuilt 1965 · S/N 18256547 N8447XHill Gregory J · York, PABuilt 1961 · S/N 17248947 N8447ZKorenko Kirk A · Granite Bay, CABuilt 1963 · S/N 205-0447 N84488Wheeler Michael T · Chicago, ILBuilt 1973 · S/N 18261872 N84489Rinkenback Keven H · Kailua-Kona, HIBuilt 1970 · S/N 17258491 N8448GMidwest Aviation Services LLC · Kendallville, INBuilt 1965 · S/N 15062548 N8448MMohamed Jaleel · Dallas, TXBuilt 1969 · S/N A1500148 N8448UGillis Christopher Paul · Fredericksburg, VABuilt 1964 · S/N 17252348 N8448XPritchard Jason T · Blaine, WAS/N 46615 N84492Robinson William D · Greer, SCBuilt 1973 · S/N 18261874 N84497N84497 LLC · Omaha, NEBuilt 1974 · S/N 18801989T N8449EJprg Aviation Inc · Orlando, FLBuilt 1979 · S/N 17272204

Back to AD 87-20-03 R2