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.
N1535SGerard Aircraft Inc · Johnson, KSN1535ZGsp Aviation LLC · Wichita, KSN1538SDeneve Allen J · Herndon, VAN1539ZGelber Lisa G Trustee · Tujunga, CAN1544SSharrits Jeffrey J · Carson City, NVN1546SBoese Bruce A · Oakdale, CAN1560ZYoung James Scott · Kemah, TXN1565ZStowe Martin D · Carlsbad, CAN1567SWegener Properties LLC Series Bonanza · Aurora, ILN1568ZKeenan Michael Richard Sr · Albuquerque, NMN1570ZSalvay Michael E · Long Beach, CAN1577ZAthuil Philippe · Beverly Hills, CAN1578ZProctor Brian S · Leesburg, TXN1580ZLiebmann Christopher J · Tehachapi, CAN1582ZAugust Aero LLC · Kalispell, MTN1585ZKnoche Matthew · Clarkston, MIN1586ZJoe L Fisher · Downers Grove, ILN1587ZGlittenberg Bryson · Flower Mound, TXN1593SHoward Paul D Jr · Williamson, WVN1593ZButler Richard Austin · Gatesville, TXN1594ZWondra Wayne L · Friendswood, TXN1596ZBarnett Paul S · Brookhaven, MSN1598SDougherty William G · Hacksneck, VAN1598ZMitchell Lester L · Okmulgee, OKN161WCater Christopher B · Lowell, MIN1708WCassaday Jonathan A · Visalia, CAN1713GRight Away Trucking Inc · Hazlehurst, GAN171HTodd Doug · De Witt, IAN171JTropicaire LLC · Hamilton, MTN1720GRegistration Pending · Kalispell, MTRegistration pending, pending cancellationN1721GCorlett Samuel E · Fort Worth, TXN1722TNoldin John · Griffith, INN1728GMeyer Fred F · Hampshire, ILN172QBonanza N172q LLC · Cedarburg, WIN1733GAlpine Aviation Inc · Mclean, VAN1737GBraly John E · Surprise, AZN1738GSchneider Joel A · Cerrillos, NMN173QLively Scott Jacob Charles · Greenbrier, ARN1744GWelsh Ayden · Dayton, OHN1746GFrasier Samuel · Gainesville, FLN1765GGivens Thomas A · Southern Pines, NCN1781GPinegar Aviation Services LLC · Ridgeland, SCN1788GTolbert Morgan Leslie · Bernardsville, NJN178QRega Consulting Inc · Port Orange, FLN1792GHelminiak Jon · Milwaukee, WIN1795GProps2jets LLC · Bolingbrook, ILN1797GTabor Tobey R · Ventura, CAN17MABearden James D · West Point, MSN17PKSmith Kevin B · Camden, NCN182QWhitt Carson M · Deland, FL
Back to AD 64-27-01