AD 95-09-13
Registered aircraft · 1,061
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:95-09-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:95-09-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:95-09-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:95-09-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.
N762TBAero Crafter LLC · Miami, FLN763EAHyannis Air Service Inc · Hyannis, MAN763JCPilot Services Of Ohio LLC · Loveland, OHN764EAHyannis Air Service Inc · Hyannis, MAN764PBBisono Pablo R · Guaynabo, PRN767ZRubin Broadcasting Inc · Dallas, ORN769EAHyannis Air Service Inc · Hyannis, MAN76MJJzw Aviation LLC · North Salt Lake, UTN771EAHyannis Air Service Inc · Hyannis, MAN775RCAirswiss Inc · Wilmington, DEN787DRBad Aire LLC · Aledo, TXN789PTValiair Limited Company · Casper, WYN789RPBrindle Concepts LLC · Hanover, PAN78DGUsac N78dg LLC · Wall Township, NJN78KC5634 Aviation LLC · Flowery Branch, GAN78NGRam Aero Development Inc · Waco, TXN794PCFlioway LLC · Iowa City, IAN797RACool Air Travel LLC · Macon, GAN799ESFive Boys Flight Training LLC · Matthews, NCN79BPOrion 207 LLC · Harpswell, MEN79DCBnb Marine LLC · Miami, FLN79FWDaniel King Aviation LLC · Dover, DEN79JFFour Twenty One LLC · Kalispell, MTN79PPJon Gibson Co · Cameron Park, CAN800BAN8vv Inc · Corpus Christi, TXN802HLAir Hammer LLC · Wilmington, DEN805PRValiair Lc Trustee · Casper, WYN808BVFlying Dutchman LLC · Waipahu, HIN809RQSouth Aero Inc · Albuquerque, NMN80BSSonrise Aviation LLC · Portland, INN80JJZing Aviation And Marine LLC · New Smyrna, FLFirst renewal noticeN80LGTru North Aviation LLC · Ironwood, MIN810BWHyannis Air Service Inc · Hyannis, MAN811NATm Aero LLC · Riverview, FLN811PGH&S Aircraft LLC · Lewes, DEN812SRVantage Point Northwest Aviation LLC · Sheridan, WYN817LLJg Aero LLC · Clermont, FLN8181GAirplane LLC · Coeur D Alene, IDN818AKWhirley Robert G · Santa Rosa, CAN818ANBank Of Utah Trustee · Salt Lake City, UTN818DHCouch Fred · Fort Worth, TXN818TKInternational Air Services Inc Trustee · Carson City, NVN818XJays Aircraft Maintenance Inc · Costa Mesa, CAN819RARonald Jinsky LLC · Beloit, WIN81LPSky West Aviation Inc Trustee · Albuquerque, NMN81RDPapaco LLC · Green Cove Springs, FLN821KAKa Consulting LLC · San Juan, PRN821TTHome By Dark LLC · Fredericksburg, TXN822BKPropilot LLC · San Juan, PRN824RBShark Water Systems LLC · Hobbs, NM
Back to AD 95-09-13