Registered aircraft · 17,027

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.

N3200UAnderson & Assoc Attorneys At Law Pc · Virginia Beach, VABuilt 1962 · S/N 18254600 N3200YCondo Gerardo B · Miami, FLBuilt 1962 · S/N 18254200 N3201SBoder Eric T · Knoxville, TNBuilt 1964 · S/N 18255701 N3201XSale Reported · Glen Allen, VASale reportedBuilt 1966 · S/N 15064601 N3202LMatta Figueroa Eduardo · Chapman, KSBuilt 1967 · S/N 17256102 N3203UKuykendall Kirk O · Lakeside, ORS/N 18254603 N3204JBecker Charles A · Rice Lake, WIBuilt 1966 · S/N 15065904 N3204UBlue Sky Flyers Inc · Punta Gorda, FLBuilt 1962 · S/N 18254604 N3204XKulesza Roman · Noblesville, INBuilt 1967 · S/N 15064604 N3205UBanducci Debra L Trustee · Bakersfield, CABuilt 1963 · S/N 18254605 N3205XAvery Jackson R · Ontario, ORS/N 15064605 N3207SSouthern Star Aviation LLC · El Campo, TXBuilt 1964 · S/N 18255707 N3207UTaf Aerial Services LLC · Beeville, TXBuilt 1963 · S/N 18254607 N3208JLandon Christopher L · Portland, ORBuilt 1966 · S/N 15065908 N3208SZirul James V · Kenai, AKBuilt 1964 · S/N 18255708 N3208UDiller Larry K · Fairview, MIBuilt 1963 · S/N 18254608 N3208XRhodenbaugh Mitchel D · Wyndmere, NDBuilt 1966 · S/N 15064608 N3208YHamilton Triple C Farms · Ririe, IDFirst renewal noticeBuilt 1962 · S/N 18254208 N3210SGore Range Aviators LLC · Kremmling, COBuilt 1964 · S/N 18255710 N3210UHaas Todd · Pecatonica, ILBuilt 1963 · S/N 18254610 N3210YBergren William · Des Moines, IABuilt 1962 · S/N 18254210 N3211JGo Captain LLC · Lake Worth, FLBuilt 1966 · S/N 15065911 N3211SNoble Tom R · Winnsboro, TXBuilt 1964 · S/N 18255711 N3211YFour M Properties LLC · Prague, OKBuilt 1962 · S/N 18254211 N3212JBrown Joseph E · Palmdale, CABuilt 1966 · S/N 15065912 N3212LBlackstone Rotorcraft Inc · Hartselle, ALBuilt 1967 · S/N 17256112 N3212TRichmond Timothy R · Deland, FLBuilt 1967 · S/N 17700512 N3213SRosengrants Matthew R · Walsh, COBuilt 1964 · S/N 18255713 N3213XAlrubaiie Ihssan R · Fort Worth, TXBuilt 1966 · S/N 15064613 N3213YFletcher Jerry D · Yukon, OKBuilt 1962 · S/N 18254213 N3214TJohnson Hugh S · Rochester, NYBuilt 1967 · S/N 17700514 N3214UBibus Michael A · Austin, MNBuilt 1963 · S/N 18254614 N3215TMcgee Debra L · Tuscola, TXBuilt 1967 · S/N 17700515 N3215XVoltmer Benjamin P · Excelsior Springs, MOBuilt 1966 · S/N 15064615 N3216TWss Aviation Inc · Jerseyville, ILBuilt 1967 · S/N 17700516 N3217JMalinchak Louis Trustee · Bristow, OKBuilt 1966 · S/N 15065917 N3217SGrotbeck Christopher L · Albuquerque, NMBuilt 1964 · S/N 18255717 N3217YBrowne Robin P · Dallas, TXBuilt 1962 · S/N 18254217 N3218JKanooth Steven L · Washougal, WABuilt 1966 · S/N 15065918 N3218KSteinhausen Darrell · Torrington, WYBuilt 1967 · S/N 15065356 N3218TShepherd Darren · Shepherdsville, KYBuilt 1967 · S/N 17700518 N3218URadford Tara Lynn · Elmira Heights, NYBuilt 1963 · S/N 18254618 N3218YCollins Marcus E Jr · Camilla, GABuilt 1962 · S/N 18254218 N3219LBlock Taylor I · Sibley, IAS/N 17256119 N3219SYogodzinkski Steve M · Amberson, PAS/N 18255719 N321BMMacintosh William J · Simpsonville, SCBuilt 1966 · S/N 17254361 N321DGAdkison Edy P · Riverside, CABuilt 1969 · S/N 21059201 N321PAFosston Flying Club Inc · Fosston, MNBuilt 1971 · S/N 17260202 N321TXMartin James K · Kingsville, TXBuilt 1967 · S/N 15067252 N3220YTanner Fred E · Westville, FLS/N 18254327

Back to AD 72-03-03 R3