AD 60-01-07
Registered aircraft · 3,967
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-01-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-01-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-01-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-01-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.
N1270CSchnack Kenneth L · Crescent, IAN127GSSanoski Gregory G · Talkeetna, AKN1280CRoesch Karl L · Arlee, MTN1282CSpivey Harold E · Thomaston, GAN1283CZawada Matthew J · Roberts, MTN1289CGordon Robert Earl · Sanford, NCN12MZRatfield Dwaine C · Onamia, MNN12TASky West Aviation Inc Trustee · Albuquerque, NMN1300CSelf James M · Fennville, MIN1301CPiper Aviation Museum Foundation · Lock Haven, PAN1303CRodriguez Isaac J · Fort Smith, ARN1308CHahn Aviation Inc · Troy, OHN1312CApplegate Paul H · Queen City, MON1320CToney Tasha Fay · Lafayette, INN1324CLawrence Mark J · Rouses Point, NYN1329CHughes Steve D · Ellsworth, WIN1335CDorn Kevin J · De Pere, WIN133FKing Tyler B · Saint Stephen, SCN1343CNimer David K · Malad City, IDN1344CCreasy Frank E · Suffolk, VAN1346CWorden Gail · Burt, MIN136JMGregory Warren D Jr · Aguila, AZN1391CSale Reported · Beech Creek, PASale reportedN1393CHayden Daniel · North Pole, AKN1397CDerr Rodney W · Frackville, PAN1399CShankster Thomas G · Aurora, CON13DBBauer Dereck R · Springfield, ORFirst renewal noticeN13YFTemple Peter L · Harrisville, NHN1404ALindinger John I · Auburn, NEN1405CGbq LLC · New Prague, MNN1407CLafreniere Joseph A · Harmony, MNN1411APetz Matthew M · Sandpoint, IDN1411CBraden James L · Hillsboro, KSN1412CStanley Gregory S · Glasgow, MTN1415AHock Wesley S · Holbrook, NEN1418CWaaam Volunteer Flying Association LLC · Hood River, ORN1421AKoplitz Wesley D · Oshkosh, WIN1424AStacey Steve L · Hutchinson, KSN1427CGdm Properties LLC · Huron, OHN1428CHolder Ward S · Oxnard, CARegistration revokedN1429CLarge Jonathan B · Mahnomen, MNN1431AKoiter Jason A · Prescott Valley, AZN1434CSherman Jeff Co Ow · Elkhart, INRegistration revokedN1437CChilders Daniel A · Hartwell, GAN14398Dyke Milo D · Hazen, NDN143JJKinery Clifford J · Kewadin, MIN1440CChamberlain Howard D · Lisbon, OHFirst renewal noticeN144JWWarren Joy A · White Lake, MIN1456AMcbride Michael S · Allentown, PAN1457ASanderson Michael E · Newberg, OR
Back to AD 60-01-07