AD 64-27-01
Registered aircraft · 778
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:64-27-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:64-27-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:64-27-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:64-27-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.
N100FBHoffman Swen · Sedalia, CON106NChenevert Eric M · Clarence, NYN10ULSurber Medical Enterprises LLC · Waverly Hall, GAN10WRWilson Keith · Saint Joseph, MIN111CVN2xt LLC · Austin, TXN111YBVanicek Nicholas Andrew · Whispering Pines, NCN112SPowell Paul L · Rancho Cucamonga, CAN113VSaravis Darren S · Long Beach, CAN119JSFennen David A · Katy, TXN11JQLosey Charles N Jr · Oneida, TNN121BEKrdm LLC · Fallon, NVN122SJDeloof Dion S · Austin, TXN12KCHeath David A Trustee · Cottonwood, AZN12PMFlying Bald Eagles Inc · New Lenox, ILN138GGardiner Alan H · Waterford, CTN13RTWoodhouse Dave · Battle Creek, MIN1400GRotor Spec Aviation LLC · Star, IDN1404GJkc Farm LLC · Chinook, MTN1405GLefever Larry R · Fall City, WAN1408GMorris Travis T · Chandler, AZN1412GBruch Lance J · Emmetsburg, IAN1416GNixon Terry L · Enid, OKN1417GRomney James J · Fruit Heights, UTN1419GMcneal James B · Beaufort, SCN1427GCarter Geoffrey R · Ormond Beach, FLN1437GMason Mark D · Brighton, CON143KPescitelli Paul · Atlanta, GAN1448GMotions Dynamics LLC · Campbellsville, KYN144FFoster Gary E · Kress, TXN144GMWilliams David · Golden, MON1454GN1454g LLC · Knoxville, TNN1455GNell James E · Pagosa Springs, CON1459GBeeson Chris · Graford, TXN1477GDobson John F · Union, WAN1485GHarris John F III · Louisburg, NCN1497GDiaz Jose R · Bakersfield, CAN14FMDurbin Gregory M · Dallas, TXN1500SCianchette R Scott · Hermon, MEN1501STaylor Counsel LLC · Hoschton, GAN1502SMakiva Sasha · Sonoma, CAN1505SBluboco LLC · Northville, MIN1507SArteta David A · Wake Forest, NCN1510SClark Lahn F · Pasco, WAN1512SIrwin Dennis R · San Diego, CAN1525SFreund Edmund A · Lodi, CAN1526SMears Bradley J · Burlington, NCN1528SWilson Brent S Trustee · Dyer, NVN152TConrad Clayton M · San Jose, CAN1530SThrailkill Robert W · Stockton, CAN1532ZFlying Y Farms LLC · Klamath Falls, OR
Back to AD 64-27-01