AD 89-18-08
Registered aircraft · 1,772
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:89-18-08')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:89-18-08')
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:89-18-08') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:89-18-08') 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.
N1366RParodi Carlos Guillermo · Austin, TXN1369RRyals Jon Harris · Billings, MTN1376RParker Brian L · Columbus, GAN1377RHendrix David S · Benbrook, TXN1385RCulleton Frederic · Flowery Branch, GAN1388RTrybe LLC · Frisco, TXN1390RYancy Timothy J · Chino Hills, CAN1391RMccarthy Daniel J · San Diego, CAN1395RKing Rodney R · Lucedale, MSN1396RHodges John J · Cleburne, TXN1398RHopland Steven R · Johnson City, TNN141ACGann Steve W · Southaven, MSN144CCNightingale William T III · Rancho Cucamonga, CAN144RLHanshew James M · Phoenix, AZN148RRDunbar Richard · El Dorado Hills, CAN1502RSale Reported · San Diego, CASale reported, pending cancellationN1503RBeck Wally J · Davenport, IAN1504RFlying Tiger LLC · Broomfield, CON1508RAmspoker David A · Kingman, AZN1515ROwen Ray M · Columbia Station, OHN1516RMckenzie Pools Inc DBA · Springfield, ORFirst renewal noticeN1519RSims John · Ingleside, TXN1520Littler David E · Largo, FLN1520RCastro Jose M · Conway, ARN1521RPerkins J R III · The Dalles, ORN1523RDement Myers Michael W · Newberg, ORN1527RFilkins Barbara L · Fillmore, CAN1529RBall Chad M · Delaware, OHN1531RMorgan Virginia K · Artesian, SDN1532RAdkins Todd D · Manassas, VAN1533RAnderson Michael · Byhalia, MSN1536RCape Cod Aero Club LLC · Falmouth, MAN1538RAction Aerospace LLC · Bluffton, SCN1540RPolar Tigers Inc · North Oaks, MNN1541RHall Daniel · Haskell, OKN1542RHoose Michael J · Cortland, NYN1543RHettlinger Eric R · Terre Haute, INN1545RSanders Harrison S · West Columbia, TXN1548RJohnson Jimmy G A III · Edmond, OKN154GRRussell Gregory · Stevensville, MDN1555RDickenson William P · Lockport, NYN1558RTaylor Scott Douglas · Bethlehem, CTFirst renewal noticeN1559RMoore Kira G · Newcastle, CAN155BYYount Brian C · Fullerton, CAN1560RAbria Consulting LLC · New Milford, NJN1561RKimmerer William J · Berkeley, CAN1562RArnesen Thomas · Sioux Falls, SDN1568RRobinson Leonard C · Boca Raton, FLN1572RBurke Kenneth L · Colleyville, TXN1573RGrand Scott LLC · Okemos, MI
Back to AD 89-18-08