Registered aircraft · 56,580

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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.

N3579YReal Property Services LLC · Bentonville, ARBuilt 1962 · S/N 18254479 N357BCChristopher Brian A · Panama City Beach, FLBuilt 1998 · S/N 18280242 N357CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281509 N357DWFlight Training Aircraft LLC · Wilmington, DEBuilt 2005 · S/N 172S9820 N357ESReeno Aviation LLC · Lewisville, NCBuilt 1997 · S/N 17280007 N357HMH & M Aviation LLC · Madison, MSBuilt 2004 · S/N 18281338 N357HTBas Part Sales LLC · Greeley, COS/N 18267806 N357KFAirmart Inc · Lexington, KYBuilt 1998 · S/N 18280189 N357LCSkywagon Ventures LLC · Anchorage, AKBuilt 1981 · S/N 18504295 N357MEMichigan Dept Of Natural Resources · Roscommon, MIBuilt 2000 · S/N 18280854 N357MGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 172S10259 N357NSKessler Garry A · Lansing, WVBuilt 1969 · S/N 33701222 N357ZCowden Flying Services Inc · Ft Worth, TXS/N 18280093 N358Bipes Anthony · Forest Lake, MNBuilt 1967 · S/N 337-0737 N35801Perkins Richard D · East Otto, NYBuilt 1968 · S/N 17256970 N35802Boeing Employees Flying Association Inc · Ridley Park, PAS/N 17256971 N35806Air Dakota Flite Inc · Hettinger, NDBuilt 1973 · S/N 21060011 N3580JJamieson Robert F · Friday Harbor, WABuilt 1965 · S/N 15061280 N3580QSale Reported · Boise, IDSale reportedBuilt 1973 · S/N 17261680 N3580UShiels Patrick Trustee · Flagstaff, AZBuilt 1963 · S/N 18254980 N3581Lewis L Dwight Jr · Lopez Island, WABuilt 1961 · S/N 18051056 N35810Mcintosh Aaron · Caldwell, TXBuilt 1968 · S/N 17256976 N35812Cielo Vista Inc · Milford, DEBuilt 1998 · S/N 18280154 N35813Davis Daniel E · Doniphan, MOBuilt 1968 · S/N 17256978 N35815Cm3 LLC · North Las Vegas, NVBuilt 1968 · S/N 17256979 N3581FSkyline Aviation Services LLC · Miramar, FLBuilt 1973 · S/N A1500413 N3581QQuantie Harold G · Locust Grove, OKBuilt 1973 · S/N 17261681 N35821Coachair Inc · Groveland, CABuilt 1976 · S/N 177RG1056 N3582CBenedict Larry D · Dexter, NMBuilt 1955 · S/N 26626 N3582DFrench Guy · Maple Valley, WABuilt 1956 · S/N 27125 N3582JMorris Jon · Thatcher, AZBuilt 1965 · S/N 15061282 N3582SMcmath Albert J Jr · Onley, VABuilt 1963 · S/N 17250782 N3582UMorton Construction Inc · Stillwater, OKBuilt 1963 · S/N 18254982 N3582YErkens Ronald B · Queen Creek, AZBuilt 1963 · S/N 18254482 N35833Williams David Wayne · Ivins, UTBuilt 1976 · S/N 177RG1057 N35837Smernoff Michael J · Des Plaines, ILBuilt 1975 · S/N U20602749 N3583JVali Air Service LLC · Livingston, MTBuilt 1965 · S/N 15061283 N3583SWalls Jerry L · Hawley, TXBuilt 1963 · S/N 17250783 N3583YCollins Carl H · Longview, TXBuilt 1962 · S/N 18254483 N35849Gilliam Robert L · Islamorada, FLBuilt 1976 · S/N 177RG1060 N3584CSnyder Kathryn J · Sutherland, NEBuilt 1955 · S/N 26628 N3584LKlesser Zachary S · Coronado, CABuilt 1965 · S/N 15062384 N3584SPaul Aviation LLC · Wasco, CABuilt 1963 · S/N 17250784 N3584UMagic Valley Aero Club Inc · Twin Falls, IDBuilt 1963 · S/N 18254984 N3584VMurdoch Bryan · Lantana, FLBuilt 1975 · S/N 15076553 N3584YHassler John Cameron · East Helena, MTBuilt 1962 · S/N 18254484 N35850Willke Ronald S · Edgewood, TXBuilt 1976 · S/N 177RG1061 N35851Northwest Passage LLC · Anchorage, AKS/N U20602757 N35852Taylor Bruce D · Cedar Rapids, IAFirst renewal noticeS/N 177RG1062 N35858Watkins Rickar D · Roseburg, ORBuilt 1976 · S/N 177RG1063

Back to AD 79-10-14 R1