AD 97-01-13
Registered aircraft · 54,837
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:97-01-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13')
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:97-01-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13') 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.
N2299CMiller William C · Boise, IDN2299GLewis Frank B · Meeteetse, WYN2299JMclaughlin Edward T · Silverdale, WAN2299TC And L Outfitters LLC · Everglades City, FLN2299XSturgeon Keith A · Saginaw, TXN229ANCalifornia In Nice Inc · San Jose, CAN229BADavila Associates · Dorado, PRN229CN229c LLC · Holt, MOFirst renewal noticeN229CSChicostate Aviation LLC · Wilmington, DEN229DKKoerkenmeier James J · Carlyle, ILN229NYCivil Air Patrol Inc · Maxwell Afb, ALN229WWMcgregor Daniel A · Denali Park, AKN22BZ8k Investments LLC Series Cessna 150 · Perryton, TXN22CRegistered aircraftN22CBVollstedt Gregory Scott · Anchorage, AKN22CFGame Equipment Services LLC · Midland, TXN22CMDavis Frederich K · Dunbar, PAN22CVMcginley Donald J · Port Orange, FLN22DECrawford Edgar A · Locust Grove, GAN22DXHawk Daniel G · Cocoa, FLN22ECDoose Christopher A · Memphis, TNN22FBWilson Travis · Beaver Dam, KYN22FGState Of California Department Of Fish And Game · Sacramento, CAN22GCSkydive Ky LLC · Cecilia, KYN22GPDunkelburg David L · Milton Freewater, ORN22JNRegistered aircraftN22KWFinn Capital LLC · San Mateo, CAN22MDewitt Josiah · Renton, WAN22MDHolland Bryan K · Sterling, AKN22NEEvmed LLC · Littleton, NCN22NNInternational Air Services Inc Trustee · Carson City, NVN22NRJefferson Aviation LLC · Seville, OHN22PNLingle Gordon D · Gun Barrel City, TXN22REStanley Aero Club Inc · Belmont, NCN22RWDenison Scott E · Gainesville, TXN22SDGordon Scott K Trustee · Tucson, AZN22TENv5 Geospatial Inc · Sheboygan Falls, WIN22TGChin-Loy Christopher Waynetrustee · Tamarac, FLN22VFAir Conejos LLC · El Paso, TXN22W22w LLC · Tacoma, WAN22WGCorpat Inc · Missoula, MTN22WREz Enterprises LLC · Montrose, CON22XXHeath Michael A · Barnet, VTN22ZJSaydun LLC · Richardson, TXN23001Henshaw Edward C · Vian, OKN23009Hopkins Francis · Wilmington, DEN2300CWasp Air LLC · Hamilton, MTN2300PNess Dana E · Chester, MTN23012De La Fuente Carlo H · Lompoc, CAN23015Schalk Rudolph A · Morgan Hill, CA
Back to AD 97-01-13