Registered aircraft · 40,394

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

N9029YJohnson Scott W · Saline, MIBuilt 1970 · S/N 18-8905 N902AZSantiago Felipe · Miami, FLBuilt 1981 · S/N 17275091 N902CWhite Edwin W · Eagle River, AKBuilt 2001 · S/N 2162 N902CCVan Flve Klub Inc · Holt, MNS/N 9902CC N902FAVero Technical Support Inc · Pensacola, FLBuilt 1980 · S/N 17273785 N902FCSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2003 · S/N 2842174 N902GRWright Allan M · Los Gatos, CABuilt 2002 · S/N 2411 N902HMacvey Troy R · Milan, INBuilt 1971 · S/N 17259252 N902NSRegistration Pending · Pottstown, PARegistration pendingBuilt 1981 · S/N 17275415 N902PADefranco Peter Jr · Hueytown, ALBuilt 2002 · S/N 2843530 N9030JSunrise Aviation Group LLC · Kalispell, MTBuilt 1966 · S/N 28-3058 N9030LDavis Robert L · Seymour, TNBuilt 1970 · S/N 216-70 N9031JBaumgartner Matthew J · Federal Way, WABuilt 1966 · S/N 28-3059 N9031LSanderlin Doulgas C · Wasilla, AKBuilt 1970 · S/N 253-70 N9032LJohnson Robert W · Buffalo, SDBuilt 1970 · S/N 259-70 N9033JBernstein Matthew D · North Charleston, SCBuilt 1966 · S/N 28-3062 N9034JGrammer Steve J · Redding, CABuilt 1966 · S/N 28-3063 N9036DKranz Monte L · Eagle Butte, SDBuilt 1958 · S/N 22-6174 N9036JBernau Bodies Fitness LLC · Mesa, AZBuilt 1966 · S/N 28-3066 N9036KGriffiths Gregory S · Johnson City, NYBuilt 1977 · S/N 28-7816184 N9036LWhitmer Charles W · Fairbanks, AKBuilt 1970 · S/N 264-70 N9036NRobinson Helicopter Co · Torrance, CABuilt 1981 · S/N 0089 N9037JMcgough Julie E · Red Oak, TXBuilt 1966 · S/N 28-3067 N9038DJones Michael D · Eagle River, AKBuilt 1958 · S/N 22-6176 N9038HPeterson Todd B · Cameron Park, CABuilt 1975 · S/N 17265912 N9038KNorthwest Aviation LLC · Gig Harbor, WABuilt 1977 · S/N 28-7816185 N9038YRodriguez Juan M · Grass Valley, CABuilt 1983 · S/N FM2 N903CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8327 N903FCSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2003 · S/N 2842175 N903KCHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 1991 · S/N 1640 N903NSAmerican Patrols Inc · Midland, TXBuilt 1976 · S/N 17267441 N903SDWernli Donald R · Perry, IABuilt 2003 · S/N 2437 N903USSchneider Charles · Sioux Falls, SDBuilt 1966 · S/N 28-3068 N9040JEllis James E Trustee · Harvard, MABuilt 1966 · S/N 28-3070 N9040KGidden Aviation LLC · Katy, TXBuilt 1977 · S/N 28-7816186 N9040PMcclure Jared · Claremore, OKBuilt 1988 · S/N 1152 N9041DHamlin Ryan C · Naples, MEBuilt 1958 · S/N 22-6179 N9042DGage Ricky D · Lewiston, IDBuilt 1958 · S/N 22-6180 N9042HSt Pete Aviation Services LLC · St Petersburg, FLS/N 17265914 N9042JRenfroe Charles R · Panama City, FLBuilt 1966 · S/N 28-3073 N9042QTumbleweed Leasing Co Inc · Salt Lake City, UTBuilt 1976 · S/N 172-67996 N9043HPinter Seth K · Abbotsford, WIBuilt 1975 · S/N 17265915 N9043JHunter Lauchlin S Jr · Alexander City, ALS/N 28-3074 N9044DArctic Backcountry Flying Service LLC · Kotzebue, AKBuilt 1958 · S/N 18-6788 N9044FFiggins Matthew J · Stewardson, ILBuilt 1976 · S/N 28-7790277 N90450Air & Sea Leasing Inc · Cahokia, ILBuilt 1981 · S/N 0120 N90459Maness William A · North Pole, AKBuilt 2008 · S/N 1-1 N9045DLewis Elijah J · Luthersville, GABuilt 1958 · S/N 22-6183 N9045JLandsgaard Theodore · Rosamond, CABuilt 1966 · S/N 28-3076 N9045KHounslow Michael L · Rockville, MDBuilt 1977 · S/N 28-7890173

Back to AD 79-10-03 R2