Skip to content

Registered aircraft · 40,396

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.

N741DPPleasant Aviation LLC · Mount Pleasant, TXBuilt 1974 · S/N 17264611 N741DWCub Driver LLC · Morgan, UTBuilt 2005 · S/N PA0205 N741FLFerrario Michael R · San Rafael, CABuilt 1972 · S/N 28-7225578 N741GSReform Friendly Flyers LLC · Buhl, ALBuilt 1970 · S/N 17259111 N741LClarke Adam M · Lompoc, CABuilt 2004 · S/N 1001 N741RASkyline Solutions Inc · Deland, FLBuilt 1989 · S/N 2841137 N741SSlavick Dennis M · Palm Desert, CAS/N 49 N742United States Department Of Agriculture · Cedar City, UTBuilt 1964 · S/N 18-8146 N7420GKellum Richard A · Seattle, WABuilt 1970 · S/N 17259120 N7420WN7420w LLC · Halethorpe, MDBuilt 1963 · S/N 28-1308 N74218Grumman Tiger LLC · Moorpark, CABuilt 1975 · S/N AA5B-0164 N74219Cmcs Aviation LLC · Atlantic Beach, FLBuilt 1975 · S/N AA5B-0165 N7421GLibby Matthew P · Castle Hill, MEBuilt 1970 · S/N 17259121 N7421VYacuzzi Gerald A · Quinque, VABuilt 1975 · S/N 20-1155 N7421WOcerg Holdings LLC · Springdale, PABuilt 1963 · S/N 28-1309 N74225Campbell Thomas J III · Good Hope, GABuilt 1975 · S/N AA5B-0166 N7422DEvans Clyde Joseph · Muscatine, IABuilt 1957 · S/N 22-5183 N7422GLafayette Escadrille Flying Club · Rock Spring, GABuilt 1970 · S/N 17259122 N7422RCastillo Alex R · West Covina, CABuilt 1966 · S/N 28-21948 N7422VPanto Anthony · Jackson, NJS/N 20-1156 N74237Carino Jane Liu · Buckley, WABuilt 1975 · S/N AA5B-0169 N74243Marion Tiger LLC · Marion, INBuilt 1975 · S/N AA5B-0172 N7424DBradley Bane L · Lyndonville, NYBuilt 1957 · S/N 22-5185 N7424PHutcheson Raymond E · Lawrence, INBuilt 1961 · S/N 24-2612 N7424RAscend Aviation LLC · Bountiful, UTBuilt 1966 · S/N 28-21952 N74257Norton John B · Colorado Springs, COBuilt 1946 · S/N 1370 N7425GSmoke Eagles Inc · Downey, CABuilt 1970 · S/N 17259125 N74261Cunningham Glenn C · Manvel, TXBuilt 1975 · S/N AA5B-0176 N74262Mckay William J · Maitland, FLBuilt 1975 · S/N AA5B-0177 N7426GProvoncha Tina · Oak Harbor, WABuilt 1970 · S/N 17259126 N7426WGreen William · Mancelona, MIBuilt 1963 · S/N 28-1314 N74270R & D Bennett LLC · San Jose, CABuilt 1975 · S/N AA5B-0178 N74275Dail Alan Scot · Virginia Beach, VABuilt 1975 · S/N AA5B-0181 N74276Steinke Matthew R · Gibson, IABuilt 1975 · S/N AA5B-0184 N7427GWilliams Jason R · Cordova, TNBuilt 1970 · S/N 17259127 N7427RVasconcelos Kathleen Marie · Woodsville, NHBuilt 1966 · S/N 28-21956 N7427WWingswat LLC · Placentia, CABuilt 1963 · S/N 28-1315 N7428RKnaust William C · Gig Harbor, WABuilt 1966 · S/N 28-21958 N74292Patel Kalpesh · Chevy Chase, MDBuilt 1975 · S/N AA5B-0187 N74298Ariel Aircraft Corp · Wilmington, DEBuilt 1975 · S/N AA5B-0189 N7429DTomporowski Robert C · Piesco, NYBuilt 1957 · S/N 22-5192 N7429GDiditair Inc · Knoxville, TNBuilt 1970 · S/N 17259129 N7429WJ A Piper LLC · Bancroft, IDBuilt 1963 · S/N 28-1317 N742TJInternational Air Services Inc Trustee · Carson City, NVBuilt 1997 · S/N 2268 N74302Airpower Enterprises Ltd · Tampa, FLBuilt 1975 · S/N AA5B-0190 N7430RGomez Rodolfo · Sierra Vista, AZS/N 28-21962 N7430WI Was Inverted LLC · Fort Myers, FLS/N 28-1318 N74319Koch Christopher G · Coloma, MIBuilt 1975 · S/N AA5B-0199 N7431DWilcox Darrol A · Nenana, AKBuilt 1957 · S/N 22-5190 N7431WKonkoi Roger E · Lumberton, NCBuilt 1966 · S/N 28-3758

Back to AD 79-10-03 R2