AD 67-29-01
Registered aircraft · 1,185
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:67-29-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:67-29-01')
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:67-29-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:67-29-01') 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.
N1208ZMaurice L Prince Jr Pc · Lafayette, LAN120BSkysuite Aviation LLC · Tujunga, CAN1215TShepphird John C · Reno, NVN121BWLester Jon M · Lancaster, OHN121LGPayton Kathleen · Grand View, IDN1223Z2dwh LLC · Katy, TXN122PGMcgaw Thomas D · Petaluma, CAN122RLJenaero LLC · Cincinnati, OHN123AKOptima Aviation LLC DBA · Lewisville, TXN123JJRotorwings Aviation LLC · Hebron, NEN1244YBurbank Dennis · Arcadia, OKN124AWCyalco Aviation LLC · Spencer, IAN124BZFerguson Steven L · Rawlins, WYN124VLeach Manuel R · Natchitoches, LAN1265ZGertsen Ronald H · Glenwood, NJN1268ZTodd Cori L · Gladewater, TXN1269ZChilds Lowell R · Elgin, ILN127FCalifornia In Nice Inc · San Jose, CAN127RWWindmiller David · Melville, NYN1285ZRivera Luis Jr · Spring, TXN129QFlying J Aviation Pllc · League City, TXN129STAzell LLC · Springfield, MON12BGFull Scale Aviation LLC · Mccordsville, INN12DKTim Cross Aviation LLC · Tucson, AZN12MTRegistration Pending · Mount Vernon, IARegistration pendingN12WLLauterbach Christian · Carmel, CAN1302ZPlaisier Matthew · Lafayette, TNN1305ZReynolds James Patrick · Lebanon, TNN1307Brian Michael L · Greensboro, NCN1311ZJprg Aviation Inc · Orlando, FLN1315ZRiesbeck Randall C · Waynesville, OHN131FHappy Star LLC · Baxley, GAN132TWRc Flyers LLC · Wilmington, DEN1332ZUp And Up Aviation LLC · Spring, TXN1333Beech Nut Flyers LLC · San Diego, CAN1339ZSmith Derek D · Brooks, GAN133MRPrecision Aero LLC · Wilmington, DEN134CBGlobal Coin Logistics LLC · Lexington, KYN134FLift Enterprises LLC · Lynn Haven, FLN1351ZErickson David R · West Point, UTN1357ZBromschwig Eric I · Montgomery, TXFirst renewal noticeN1365ZSkans David K · Henderson, NVN1366ZPfetsch Mitchell R · Daggett, CAN1377ZCoen Brady · Wiley, CON137FSmith Nathan · Citra, FLN138QKyff Jeffrey V · Traverse City, MIN139PTCroley John T Jr · Fitzgerald, GAN139QMoles Timothy E · New Cumberland, WVN1403G1403g LLC · Wheat Ridge, CON1409GAir Care Leasing LLC · Lamar, CO
Back to AD 67-29-01