AD 48-08-01
Registered aircraft · 1,077
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:48-08-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:48-08-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:48-08-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:48-08-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.
N1490GSmith David Brian · Indianapolis, INN1499GCrist Michael Alan · Wakonda, SDN1505ZKc Air LLC · Wellford, SCN1506ZTopspeed Black LLC · Alpharetta, GAN1513SHoward Michael G · Slaughters, KYN1517ZFreedom Aviation LLC · Beaufort, SCN1519SSimmons Gene R · Vicksburg, MIFirst renewal noticeN1522S1522s LLC · Sikeston, MON1523SMeece Edward B · Portland, ORN1524SFaris Garold D · Bay City, TXN1541ZDebonair Inc · Kansas City, MON1545SAnthony Joan Lissan · Baxter, TNN1547ZDowning Darren J · Knoxville, TNN1550ZDemos Gary D · Cable, OHN1554SBeech Babe Ltd · Colorado Springs, CON1558ZAlpha Tango Aviation LLC · Gillette, WYN1563SMiller Edward L · Santa Rosa, CAN1569ZTran Danh · Moreno Valley, CAN1573SMckee Keith L · Fuquay Varina, NCN1574SAdk Global LLC · Hollywood, FLN1574ZFernando Espinosa Aviation LLC · Helena, MTN1577GCohen Mark R · Dallas, TXN1579ZQueen Mark Allen · Adel, GAN157MDDunbar Kevin R · Belmont, NCN1583SSmythe Errol J DBA · Bixby, OKN1584SWhitlock Holdings LLC · Honey Grove, TXN1586SWits End Travels Ltd · Wilmington, DEN1588SMava Aviation LLC · Fort Worth, TXN1588ZWalker Wesley F · Rock Hill, SCN1589SHunton Paul S · Murfreesboro, TNN1589ZRiester Bernard J Jr · Auburn, NYN1592SRoach Christopher A · Mustang, OKN1597SJones William F · Seneca, SCN1599VQuigley Ryan P · Chemung, NYN15DLSchlund Bradley D · Springtown, TXN15MEnglish Dexter · Syracuse, KSN15NCHerberg Hayley · Reno, NVN162MDD Squared Aviation LLC · Fort Worth, TXN1643TWilliams Rudder · Scottsboro, ALN165MRDavid Rever Aviation LLC · Dewey Beach, DEN167MStoltzfus Jesse A · Greenfield, OHN168NLLakeside Views LLC · La Crescenta, CAN169PHunter James F · Sevierville, TNN1705GDavis Roger N · Cheshire, ORN1714GBull Rises LLC · Byron Center, MIN1718GWhitlock Charles Parker · Thompsons Station, TNN1723GDillahunty Chris D · Shaver Lake, CAN1724GNelson Debra L · Presque Isle, MEN1735GFeldhaus Joseph H · Shelbyville, TNN1740GOelrich Matthew Alan · Concord, CA
Back to AD 48-08-01