Skip to content

Registered aircraft · 72,001

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-10-06-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-10-06-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-10-06-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-10-06-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-10-06-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-10-06-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.

N12933Van Anda Aviation LLC · Apopka, FLBuilt 1973 · S/N 17262384 N12935Ray Aviation LLC · Burkett, TXBuilt 1973 · S/N 17262386 N12936Quinlan Patrick J · Cooper City, FLBuilt 1973 · S/N 17262387 N1293FT-Craft Aero Club · Nampa, IDBuilt 1979 · S/N 17272987 N1293TN1293t LLC · Wilmington, DES/N 34-7250283 N12940Buffoon Flying Club · Mansfield, OHBuilt 1973 · S/N 17262388 N12943Titsworth R G · Seekonk, MABuilt 1973 · S/N 17262415 N12947Alltek Lebelle Ltd · Wilmington, DEBuilt 1973 · S/N 17262393 N1294CJel Imaging Services LLC · Rochester, NYFirst renewal noticeBuilt 1977 · S/N 17702698 N1294FClover Park Technical College · Lakewood, WABuilt 1979 · S/N 17272988 N1294XMcglynn Brian · Friday Harbor, WABuilt 1963 · S/N 167 N12951Huestis Peggy J · Havre, MTS/N 17262397 N12952Wesselhoff Rick · Sedona, AZBuilt 1973 · S/N 17262398 N12953Witmer Travis R · Odenton, MDBuilt 1973 · S/N 17262399 N12955American Patrols Inc · Midland, TXBuilt 1973 · S/N 17262400 N1295AJenski Kobie · Sutton, AKBuilt 1951 · S/N 18-1098 N1295TLutz Brian · Carmel, INBuilt 1972 · S/N 28-7205278 N1295URegistration Pending · Monroe, WIRegistration pendingBuilt 1976 · S/N 17266989 N1295XOz Aviation Inc · Cottonwood Falls, KSBuilt 1963 · S/N 168 N12960Hennessee Timothy H · New Braunfels, TXBuilt 1973 · S/N 17262405 N12968Rtd Aviation LLC · Hillsborough, NJBuilt 1973 · S/N 17262413 N1296CLogan Tom B Trustee · Coeur D Alene, IDBuilt 1977 · S/N 17702699 N1296UKirk Claire Y · Huntington Beach, CABuilt 1976 · S/N 17266990 N1296XFox Judy · Ridgefield, WAS/N 169 N12973Mor Aviation LLC · Gaithersburg, MDBuilt 1973 · S/N 17262418 N12974Forest Ken W · Wales, NDBuilt 1972 · S/N 17262419 N12976Wanda Collins Professional Pilot Services LLC · Madisonville, TXBuilt 1973 · S/N 17262421 N1297FJprg Aviation Inc · Orlando, FLBuilt 1979 · S/N 17272990 N1297JLemrich Aero Inc · Dallas, TXS/N 297 N1297TReich David W · Fort Lauderdale, FLBuilt 1972 · S/N 32-7240112 N1297XScott Benjamin D · Grove City, OHS/N 170 N12983Haman Aviation Services LLC · Nokomis, FLBuilt 1973 · S/N 17262427 N12984Go Fly Az LLC · Gilbert, AZBuilt 1975 · S/N 17702394 N12985Alamakee Flyers · Waukon, IABuilt 1973 · S/N 17262429 N12991Usda Forest Service Fepp · Columbia, SCBuilt 1973 · S/N 17262432 N12997Wausau Flying Service Inc · Wausau, WIS/N 17262437 N1299AHunsicker Greg A · Berryton, KSBuilt 2000 · S/N 80252 N1299URice Melvin G · Bridgeport, TXBuilt 1976 · S/N 17266993 N1299XMunoz David · Corona, CAS/N 2680 N1299ZWojdac David E · Mosinee, WIS/N TD-467 N129AXBradley William R · Colorado Springs, COBuilt 2005 · S/N 60326 N129BAAdvise By Air LLC · Whittier, CABuilt 2004 · S/N 18281353 N129BBLawson Michael · Englewood, TNBuilt 1969 · S/N 31-481 N129BRMiller Theodore C Jr · Edinburg, TXBuilt 2008 · S/N 52A N129CCChilds David E · Amber, OKBuilt 2002 · S/N 9951CC N129CPUpright Aviation LLC · Helena, MTBuilt 2001 · S/N 18067C N129DDDruckenbrodt Donald D · Fredericksburg, TXS/N 1393 N129FRWings Over Texas Holdings LLC · Denton, TXBuilt 1981 · S/N 17275338 N129GHWoelbing Aviation LLC · Franksville, WIBuilt 1994 · S/N M-1-1775 N129GRGunderson Marlon O · Lake Elmo, MNBuilt 2017 · S/N GR01

Back to AD 87-10-06 R1