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.

N8889EWestern New York Flying Club Inc · Bowmansville, NYBuilt 1976 · S/N 28-7690214 N8889VGarcia Hector A · Caguas, PRBuilt 1974 · S/N 17264247 N888AGKlingensmith John R · Santa Maria, CABuilt 1998 · S/N 1042 N888APAnderson Scott · Edgartown, MABuilt 1976 · S/N 28-7715105 N888AWCag International Inc DBA · Longmont, COBuilt 1973 · S/N 28-7305386 N888BMDeverapalli Vishnu Reddy · Duluth, GABuilt 1977 · S/N 28-7890282 N888BWAero Elite Inc · Wilmington, DEBuilt 1970 · S/N 28-5856 N888CBBenz James E · Pittsford, NYBuilt 1974 · S/N 17264417 N888CCStevens Terry L · New Plymouth, OHBuilt 1979 · S/N 28-7916324 N888CKRadel James C · Sunbury, PABuilt 1989 · S/N 888PM N888CMKelley Aircraft LLC · Weyers Cave, VABuilt 1976 · S/N 17267424 N888ERFrost Aviation Alliance LLC · Tampa, FLBuilt 1974 · S/N 28-7505087 N888EZRabideau Jacob N · Tehachapi, CABuilt 1983 · S/N 564 N888GCBachmann Aviation LLC · Marshall, VABuilt 2005 · S/N 3857 N888GHCardinal Gregory Joseph · Minneapolis, MNBuilt 1992 · S/N 52 N888GMStevens Ryan · Presque Isle, MEBuilt 1977 · S/N 28-7716264 N888LHReece Connor I · Green Cove Springs, FLBuilt 1997 · S/N 21045 N888SKKelly Erin C · Bend, ORBuilt 1978 · S/N 7-0407 N888TACurrier Winston F · Monroe, NHBuilt 1975 · S/N 17266196 N888TBBlock Scott · Chandler, AZFirst renewal noticeBuilt 1969 · S/N 17257895 N888TSSeher Jacob Scott · Reno, NVBuilt 2000 · S/N 80556 N888VMDaniels Michael R · Mc Donald, PABuilt 1973 · S/N 17702021 N888WTBoatman John Jr · Smyrna, TNS/N K-1 N888ZGNess Aviation LLC · Moriarty, NMBuilt 1974 · S/N 28-7525109 N8890JBlease Ronald B II · Moultrie, GABuilt 1965 · S/N 28-2865 N8890KFgds Aviation LLC · North Fort Myers, FLBuilt 1967 · S/N 28-23761 N8890VBig Q Aviation · Helena, MTBuilt 1974 · S/N 17264248 N8891JAdamson Steven C · Stockbridge, GABuilt 1965 · S/N 28-2866 N8891LSchendel-Adolf · Elk Grove, CABuilt 1974 · S/N AA5-0695 N8891NAlred Steven J · Centre, ALBuilt 1969 · S/N 28-25755 N8891VPropel Air LLC · Pottstown, PABuilt 1974 · S/N 17264249 N8892JA&R Aviation LLC · Houston, TXBuilt 1965 · S/N 28-2867 N8892VBillingsley Carl R · Henderson, TXBuilt 1974 · S/N 17264250 N8893CAirquest Aviation Lp · Butler, PABuilt 1976 · S/N 28-7615132 N8893JWare Wilson · Rockwall, TXS/N 28-2868 N8893VEast Tennessee Pilots Club · Knoxville, TNBuilt 1974 · S/N 17264251 N8894Buth Elizabeth · Wasilla, AKBuilt 1973 · S/N 478-73 N8894DPyle Jarod H · Wasilla, AKBuilt 1958 · S/N 18-6368 N8894JMenees B Martin · Little Rock, ARBuilt 1965 · S/N 28-2870 N8894VBeckworth Brad T · Jacksonville, FLBuilt 1974 · S/N 17264252 N8895JCherokee N8895j Inc · Westminster, MDBuilt 1965 · S/N 28-2871 N8895NLuque Michael J · Shinnston, WVS/N 28-25759 N8896Ausbun Taylor J · North Pole, AKBuilt 1973 · S/N 480-73 N8896DGidzinski David A · Weirsdale, FLBuilt 1958 · S/N 18-6370 N8896EN8896e LLC · Lake City, FLBuilt 1976 · S/N 28-7625165 N8896JClark Kenneth A · Mount Pleasant, ARBuilt 1965 · S/N 28-2872 N8897JShreve Gene · Fayetteville, TNBuilt 1965 · S/N 28-2873 N8897NAnderson Leroy H · San Angelo, TXBuilt 1969 · S/N 28-25761 N8898DWelty Donald Robert Jr · Glennallen, AKBuilt 1958 · S/N 18-6374 N8898JColt 45 LLC · Tulsa, OKS/N 28-2874

Back to AD 79-10-03 R2