Registered aircraft · 17,028

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:72-03-03-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') 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:72-03-03-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
  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:72-03-03-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
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.

N8391GReynolds Timothy D · Locust Grove, GABuilt 1965 · S/N 15062491 N8391JDaily Joshua J · Rochester, WAS/N 15066291 N8391ZSkelton Thomas W · Holt, MIBuilt 1963 · S/N 205-0391 N8392GSander Clay O · Mutual, OKBuilt 1965 · S/N 15062492 N8392SCooksey Dustin J · Strasburg, COBuilt 1965 · S/N 18256492 N8392URegistered aircraftBuilt 1964 · S/N 17252292 N8393LJohns Ryan · Sabillasville, MDBuilt 1968 · S/N 17256593 N8393MPatterson Robert A · Hillsboro, ORBuilt 1969 · S/N A1500093 N8393SMast Aviation LLC · Roseburg, ORBuilt 1965 · S/N 18256493 N8393ZDeal Enterprises Inc · Doran, MNBuilt 1963 · S/N 205-0393 N8394ZRegistered aircraftBuilt 1963 · S/N 205-0394 N8395GSmith David B · Indianapolis, INS/N 15062495 N8395MJuliet Foxtrot Aviation LLC · Camden, SCBuilt 1969 · S/N A1500095 N8396GBarnes Greg B · Tunas, MOBuilt 1965 · S/N 15062496 N8396MManley Steven T · Dallas, TXBuilt 1969 · S/N A1500096 N8396SRegistration Pending · Livingston, MTRegistration pendingBuilt 1965 · S/N 18256496 N8397JRegistered aircraftBuilt 1967 · S/N 15066297 N8397ZFlying H LLC · Lake Placid, FLBuilt 1963 · S/N 205-0397 N8398LWingsleasing LLC · Wichita, KSBuilt 1968 · S/N 17256598 N8398MHale Richard W · Warminster, PABuilt 1969 · S/N A1500098 N8398SRoberts Rickey J · Kamiah, IDBuilt 1965 · S/N 18256498 N8398UAdrenaline Junkies LLC · Richfield, UTBuilt 1964 · S/N 17252298 N8399LSanders George W Jr · Cloverdale, INBuilt 1968 · S/N 17256599 N8399SDenver Aviation Inc · Westminster, COS/N 18256499 N84009Swenson Catherine A Trustee · Meadow Vista, CABuilt 1969 · S/N 17258299 N8400BEdwards R Deryl · Joplin, MOS/N 15062500 N8400JBlue Wings LLC · Brecksville, OHBuilt 1967 · S/N 15066300 N8400LInstant Print Signs & Designs LLC · Kalispell, MTBuilt 1968 · S/N 17256600 N84019Snodgrass William D · Moberly, MOFirst renewal noticeBuilt 1969 · S/N 17258303 N8401JKingdom Air Corps · Sutton, AKBuilt 1967 · S/N 15066301 N8401LBlack Baron Air LLC · Kalispell, MTS/N 17256601 N8401UMorales Jerardo S · Belleville, ILBuilt 1964 · S/N 17252301 N84024Maurano Michael R · Long Island, VABuilt 1969 · S/N 17258304 N84026Smith William A Jr · Tulsa, OKBuilt 1969 · S/N 17258305 N8402LVan Bortel Inc · Victor, NYBuilt 1968 · S/N 17256602 N8402MBurke Shawn T · Flowery Branch, GABuilt 1969 · S/N A1500102 N8402UWj Rothwell Ranch Co · Hyannis, NEBuilt 1964 · S/N 17252302 N8402ZRixford Raymond Gould · Gunnison, COBuilt 1963 · S/N 205-0402 N84036Wings Over Texas Holdings LLC · Denton, TXBuilt 1969 · S/N 17258308 N8403UAnderson Larry L · Silver City, NMBuilt 1964 · S/N 17252303 N84048Kyzer Aviation Holdings LLC · Fort Mill, SCBuilt 1969 · S/N 17258314 N8404JMalphurs Larry Neil · Pooler, GAS/N 15066304 N8404MMitchell Ryan G · Ventura, CABuilt 1969 · S/N A1500104 N8404UAviation Career Enrichment Inc · Atlanta, GABuilt 1964 · S/N 17252304 N8404ZSmith Michael E · Willits, CABuilt 1963 · S/N 205-0404 N84050Alpenglow Air 2 LLC · Anchorage, AKBuilt 1969 · S/N 17258315 N8406244 Flyers · Harlowton, MTBuilt 1969 · S/N 17258319 N84063Rothermel Donald M · Mokena, ILBuilt 1969 · S/N 17258320 N8406LVee Neal Aviation · Latrobe, PABuilt 1968 · S/N 17256606 N8406SSkydive Central New York LLC · Weedsport, NYBuilt 1965 · S/N 18256506

Back to AD 72-03-03 R3