Registered aircraft · 108,428

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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.

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 N1296AN1296a LLC · Asheville, NCBuilt 1969 · S/N D-9030 N1296CLogan Tom B Trustee · Coeur D Alene, IDBuilt 1977 · S/N 17702699 N1296FWalker Brandon · Anchorage, AKBuilt 1975 · S/N 18502816 N1296GAir Dogs LLC · Watford City, NDBuilt 1976 · S/N 310R0698 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 N1297GPilot Mountain Aviation LLC · Marietta, OHBuilt 1974 · S/N 310R0003 N1297JLemrich Aero Inc · Dallas, TXS/N 297 N1297LOklahoma Cirrus LLC · Mclean, VABuilt 2003 · S/N 0713 N1297SAlpine Skylane LLC · Alpine, WYS/N 18264864 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 N1298MRedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1975 · S/N 18264280 N1298RSouthern Utah University · Cedar City, UTBuilt 1972 · S/N 30479 N1298SHighlane LLC · Phoenix, AZBuilt 1976 · S/N 18264865 N1298ZShaw Aviation LLC · Greenleaf, IDBuilt 1961 · S/N D-6738 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 N1299MMoanaviation Inc · Tampa, FLBuilt 1977 · S/N 21061932 N1299SAero Guard Aviation Insurance LLC · Lincoln, NEBuilt 1976 · S/N 18264866 N1299URice Melvin G · Bridgeport, TXBuilt 1976 · S/N 17266993 N1299XMunoz David · Corona, CAS/N 2680 N1299ZWojdac David E · Mosinee, WIS/N TD-467 N129ABPhilly Express LLC · Wilmington, DEBuilt 1994 · S/N EA-561 N129AGMarsh Equipment LLC · Aurora, ORBuilt 2024 · S/N 4496574 N129ASPyxis Air LLC · Wilmington, DEBuilt 1976 · S/N 310R0663 N129AXBradley William R · Colorado Springs, COBuilt 2005 · S/N 60326 N129BAAdvise By Air LLC · Whittier, CABuilt 2004 · S/N 18281353 N129BETextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2019 · S/N E-4129 N129BMMain Gary Michael · Haverford, PABuilt 2004 · S/N E-3588 N129BRMiller Theodore C Jr · Edinburg, TXBuilt 2008 · S/N 52A N129CCChilds David E · Amber, OKBuilt 2002 · S/N 9951CC N129CMWoodhaven Air LLC · Blue Springs, MOBuilt 1958 · S/N 35625 N129CPUpright Aviation LLC · Helena, MTBuilt 2001 · S/N 18067C N129CSGoldenstein Steven H Jr · Jurupa Valley, CABuilt 1975 · S/N 18264167

Back to AD 2007-04-19 R1