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.

N704UEWillpower Aviation LLC · Litchfield Park, AZBuilt 1976 · S/N 15078878 N704UFKimani Derrick M · Panorama Village, TXBuilt 1976 · S/N 15078879 N704UHCappiello Robert M · Santa Clarita, CAS/N 15078881 N704UPHayenga Sandra A · Granbury, TXBuilt 1976 · S/N 15078887 N704URWalker Richard D · Houston, TXBuilt 1976 · S/N 15078889 N704UTCp Aviation Inc · Santa Paula, CABuilt 1976 · S/N 15078891 N704UWJahawk Leasing LLC · Sugar Grove, ILBuilt 1976 · S/N 15078894 N704UXHlavac Mathew B · Ramona, CABuilt 1976 · S/N 15078895 N704UYTotal Aircraft Service Inc · Sherwood, ARBuilt 1976 · S/N 15078896 N704VFRegistered aircraftS/N 15078903 N704VLHattayer John M · Plainfield, CTBuilt 1976 · S/N 15078908 N704VMRegistration Pending · Navarre, FLRegistration pendingBuilt 1976 · S/N 15078909 N704VTNye Andre Marcus · Naples, FLS/N 15078914 N704VUBlue Raven Aviation LLC · Anderson, SCBuilt 1976 · S/N 15078915 N704VYPiryk Christopher M · Ocklawaha, FLBuilt 1976 · S/N 15078919 N704WBEyster Christian Charles · Sweetwater, TNBuilt 1976 · S/N 15078922 N704WCLegacy Pilot Training LLC · Annandale, MNS/N 15078923 N704WDMcdonald David R · Duluth, MNBuilt 1976 · S/N 15078924 N704WFFoxtrot Flight Training LLC · Berrien Springs, MIBuilt 1976 · S/N 15078926 N704WHEvanson Scot A · Monroe, TNBuilt 1976 · S/N 15078928 N704WNN704wn LLC · Panama City, FLBuilt 1976 · S/N 15078933 N704WRGroves Malcolm Duane · Spring Hill, FLBuilt 1976 · S/N 15078936 N704WTRodriguez Oswaldo · Tifton, GABuilt 1976 · S/N 15078938 N704WUWalker James O · Lovell, WYBuilt 1976 · S/N 15078939 N704WWLay Lawrence W · Douglass, KSBuilt 1976 · S/N 15078941 N704XBSivert Leslie A · Richmond, VABuilt 1976 · S/N 15078946 N704XGByrne Matthew · West Allis, WIBuilt 1976 · S/N 15078951 N704XLWelch Donald E · Crown Point, INBuilt 1976 · S/N 15078955 N704XNStiefer Charlie C · Durant, OKS/N 15078957 N704XSBrian Edward L · La Vergne, TNS/N 15078961 N704XVButzer Jeffrey D · Warrens, WIBuilt 1976 · S/N 15078964 N704XXSaumer Steven E · Pine City, MNBuilt 1976 · S/N 15078966 N704XYWalter Bryce D · Macomb, ILS/N 15078967 N704YASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1976 · S/N 15078969 N704YEMarshall J B · Talbott, TNBuilt 1976 · S/N 15078972 N704YLCraig Jason · Upland, CABuilt 1976 · S/N 15078978 N704YPFoss Kayla R · Anchorage, AKBuilt 1976 · S/N 15078981 N704YRB2w Corporation · Winona, MNBuilt 1976 · S/N 15078983 N704YSRepke Robert · Gainesville, GABuilt 1976 · S/N 15078984 N704YVHallmark University Inc · San Antonio, TXS/N 15078987 N704YWKummer Michael J · Floyds Knobs, INBuilt 1976 · S/N 15078988 N704YXMock Joseph R · Huntsville, TXBuilt 1976 · S/N 15078989 N704ZDHayward Stephen L · Amarillo, TXBuilt 1976 · S/N 15078995 N704ZEPlane Junkies LLC · Dover, DEBuilt 1976 · S/N 15078996 N704ZHHouse Robert E Jr · Sanford, NCBuilt 1976 · S/N 15078999 N704ZPErickson Elisabeth R · Port Townsend, WABuilt 1976 · S/N 15079005 N704ZRLikens Michael K · Labelle, FLBuilt 1976 · S/N 15079007 N704ZUWood Donald R · Cottondale, ALBuilt 1976 · S/N 15079010 N704ZWOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1976 · S/N 15079012 N70506Roesner Liselotte A · Hilton, NYBuilt 1973 · S/N U20602073

Back to AD 87-20-03 R2