AD 60-03-07
Registered aircraft · 155
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:60-03-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:60-03-07')
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:60-03-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:60-03-07') 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.
N1004PVankirk Malcolm R · Frederick, MDN1017PZeivogel Jeanine · Gulf Shores, ALN1033PProfessional Pilots Inc · Lowell, INN103RSZielke Michael M · Chuluota, FLN105EBHardy Randall B · Argyle, TXN1065PChisum Robert · Lorenzo, TXN1071PFlying Circus Aircraft LLC · Manitou Beach, MIN1089PDetert Bradley · Valparaiso, INN1116PSale Reported · Scottsville, VASale reportedN1123PRegistration Pending · Flint Hill, VARegistration pendingN1131PDBA Congdons Aviation Service · Anchorage, AKN1132PR & S Stuart Co Inc · Wilmington, DEN1134PSutton Aircraft Salvage LLC · Palmer, AKN1140PCromley Amanda J · Lewisburg, PAN1158PLorenzo Walker Institute Of Tech · Naples, FLN1166PDelaware Aircraft Trust LLC Trustee · New Castle, DEN1167PCascadia Air Ventures Inc · Winlock, WAN1172PSteed William B · Winnsboro, SCN1174PHardin John M · Terrell, TXN1189PParks Eric · Matthews, NCN1197PPenley Steven A · Corinth, TXN1207PN73481 LLC · Ault, CON1210PRegistration Pending · Independence, MORegistration pendingN1215PTucker Robert B · Melba, IDN1217Pendley Rory G · Torrance, CAN1220BWash Steven M · Austin, TXN1231PTwin Oaks Airpark Inc · Hillsboro, ORN1234PThomas Steven E · Libertyville, ILN123PJacobs Michael · Jay, OKN1255PJones Jamie · Grants Pass, ORN1271PWendt Aero LLC · Newberg, ORN1273PMatthews Grover C · Fairborn, OHN1292PEm Turbines Corp · Fort Lauderdale, FLN1305PParkhill Clifton A Jr Trustee · Oxnard, CAN1308BHopewell Jeffrey D · Temple, TXN1316PMatthews Grover C · Hardinsburg, KYN1317PWhite Christopher N · Clearwater, FLN1319PCanter Russell L · Enterprise, KSN1334PN1334p LLC · Titusville, FLN1335PRiggin Flight Service Inc · Madison, SDN1344PCrist Charles E · Waxahachie, TXN1352PHouse Travis · Bristow, VAN1367PBuzzard Air Service LLC · Carleton, MIN1381PObermueller Frederick J · Milford, NJN1384PHanson Roddy L · Butterfield, MNN1393PSeymour Lori L · Woodstock, GAN1432MLarson Sean P · Fairbanks, AKN1438PTri Rotor Spray & Chemical · Ulysses, KSN1452PSorenson Mark A · Senoia, GAN1454PLansing Community College · Mason, MI
Back to AD 60-03-07