Registered aircraft · 826

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:90-15-15-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:90-15-15-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:90-15-15-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:90-15-15-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:90-15-15-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:90-15-15-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.

N271APatty Wagstaff Aviation Safety LLC · Saint Augustine, FLBuilt 2002 · S/N 905-2002 N272SGLehner Raymond A Jr · North Fort Myers, FLBuilt 2004 · S/N 969-2004 N275MAFranzoy Steve · Salem, NMS/N 1014-2006 N2767PMatta Sam · Brookshire, TXBuilt 1976 · S/N 255-76 N276RSchwam Julie R · Hayden, IDS/N 713-93 N2778ZLarson Kris Kendrick · Fullerton, CABuilt 1978 · S/N 370-78 N278GMAmerican Champion Aircraft Corp · Rochester, WIS/N 1239-2027 N279MASd Aviation LLC · Danville, CABuilt 2007 · S/N 1040-2007 N27HWJacobs Jim · Great Barrington, MABuilt 2018 · S/N 1177-2018 N27WHAviators Unlimited Aviation Holdings LLC · Garner, NCBuilt 2007 · S/N 1045-2007 N2804ZWatson Jennifer R · San Jose, CABuilt 1978 · S/N 371-78 N282MAJ&D Aviation LLC · Dallas, TXBuilt 2004 · S/N 959-2004 N2877ZCliff Robinson Real Estate Corp · Madison, INBuilt 1978 · S/N 373-78 N287DKHemphill Holdings LLC · Hemphill, TXBuilt 2017 · S/N 1170-2017 N2885ZMclaughlin Paul E · Mansfield, OHS/N 374-78 N2891ZSale Reported · Lantana, TXSale reportedBuilt 1978 · S/N 375-78 N2896ZPotts Blaize D · Port Angeles, WABuilt 1978 · S/N 376-78 N289SAReed Gary · Bethel, OHBuilt 2005 · S/N 993-2005 N28GKMay Aviation LLC · San Diego, CABuilt 2003 · S/N 918-2003 N2907ZCabana Robert D · Cocoa, FLBuilt 1978 · S/N 377-78 N291SAWoods Aviation LLC · Kearney, NEBuilt 2005 · S/N 982-2005 N291TPSparebanc LLC · Appleton, MNS/N 889-2001 N2944ZCorcoran Brian L · Hampstead, MDS/N 378-78 N295ACFanjoy James Michael · Nehalem, ORBuilt 1995 · S/N 756-95 N2962ZMull Jason E · Chester, NYBuilt 1978 · S/N 379-78 N296ACNewton Thomas L Jr · Fredericksburg, VAS/N 770-96 N29742Payne David T · Monticello, ILBuilt 1980 · S/N 618-80 N2975WFoldesi Dennis · Merritt Island, FLBuilt 1980 · S/N 620-80 N2976ZEvans James · Millbrae, CAS/N 380-78 N2979CEnchanted Aircraft LLC · Santa Fe, NMBuilt 1980 · S/N 639-80 N297ACCavanaugh Flying Service Inc · Minden, NES/N 771-96 N2980DLimbach Ronald B · Verona, ILBuilt 1980 · S/N 642-80 N2984ZStitch Aero LLC · Sunnyvale, CABuilt 1978 · S/N 381-78 N298MASouthern Air Service Inc · Carbondale, ILBuilt 2004 · S/N 961-2004 N2991DWatkins William C · Guy, ARS/N 627-80 N2999ZGodensun Aero LLC · Sutherlin, ORS/N 382-78 N299LCFlight Contract Services Inc · Las Vegas, NVBuilt 1974 · S/N 165-75 N299SAEnterprise General Aviation Network Inc · Dell Rapids, SDBuilt 2005 · S/N 1003-2005 N29CBHouston Robert · Murray, KYBuilt 1974 · S/N 156-74 N29SGMusser Richard J · Lithia, FLBuilt 2009 · S/N 1084-2009 N2JGWetsu Enterprises Inc · Colorado Springs, COBuilt 1978 · S/N 403-78 N300AKAmerican Champion Aircraft Corp · Rochester, WIS/N 1234-2026 N300WSOdyssey Aviation LLC · Raleigh, NCBuilt 1992 · S/N 687-92 N301ACFlying Squirrel Aviation LLC · Shirley, MABuilt 1995 · S/N 744-95 N303ACUlinski Daniel J · Glen Burnie, MDBuilt 1995 · S/N 755-95 N303SBBlom Wayne E Jr · Littleton, COBuilt 2001 · S/N 887-2001 N307MJSheridan Pilots 307 LLC · Sheridan, WYS/N 137-74 N307POetting William · Midland, ORS/N 734-94 N30SBFlare LLC · Chattanooga, TNBuilt 2004 · S/N 955-2004 N31273Haselmo Zak-Newton · Park River, NDS/N 52-72

Back to AD 90-15-15 R1