AD 72-07-10
Registered aircraft · 618
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
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-07-10')
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-07-10')
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-07-10') 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-07-10') 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.
N100XXAskew Stell Blake III · Durham, NCN1012GForwalt Lucas A · Chesapeake, VAN109RWMcpherson Michael A · Stephenville, TXN10FAFlanigan Marie C · Lockport, NYN117TNNichols Timothy P · Reno, NVN12VGHashimoto Noriyuki · Rumford, MEN131Ekstrand Marshall · Lake Stevens, WAN1325RDavison Mark L · Vacaville, CAN1350RBates Victoria Anna · West Union, WVN1360RBreland James G · Laurel, MSN1372RStephenson John W · Whittier, CAN1373RSmith Paul R Jr · Hubbardston, MAN1380RNevers Joseph R II · Homestead, FLN1401TJetmro Inc · Sebastian, FLN1406RPatrick Ernest E · Lufkin, TXN1409RJersey Boys LLC · Rockledge, FLN1411RBlanton Eric W · Santa Anna, TXN1414RBerka George · Waterbury, CTN1418RHall James E · Shalimar, FLN1420RShires James D · Merrillan, WIN1421RGreenawald Richard J · San Mateo, CAN1425RCambridge Aircraft LLC · Hot Springs, ARN1428RShiner Tod W · Talking Rock, GAN1431RTwo Dot Aircraft LLC · Kalispell, MTN1433RNickell Stan A · Gilmer, TXN1434RLarson Kris K · Fullerton, CAN1438RLindsey Dustin T · Salem, ORN143RRHale Arthur H · Angleton, TXN1441RJorgensen John K · Dewey, AZN1443RBrown Jesse L · Muscle Shoals, ALN1444RRye Steve V · Dickson, TNN1448RWright Roger W · Buckeye, AZN1452RBlanton Eric W · Santa Anna, TXN1453RUnderwood David W · Nampa, IDN1458RManning Ryan E · Watsonville, CAN1461RDawson Electric Works Inc · Armstrong, IAN1477RWinski Robert L · Durango, CON1479RRosebecke Jason Eugene · Borger, TXN1481RMccord Hal E Jr · Pensacola, FLN1482RDavids Samuel W · Woodinville, WAN1483RLeduc Thomas E · Monterey, CAN1484RLopez Alfred M · Banning, CAN1485RBreeden Wayne M · Memphis, TNN1486RRiley Daniel B · Valparaiso, INN1487RShepard William E · Peoria, AZN1489RSkidmark Services Inc · Debary, FLN1491RHerring Deems · Pine Mountain, GAN1492RHacker Delbert M Jr · Granbury, TXN1497RAnthonson Douglas Etal · Cortland, NYN1498RPedersen Paul C · Barbourville, KY
Back to AD 72-07-10