AD 2005-12-13
Registered aircraft · 479
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:2005-12-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:2005-12-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:2005-12-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:2005-12-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.
N7037EHyannis Air Service Inc · Hyannis, MAN706CAHyannis Air Service Inc DBA · Hyannis, MAN717BDWeathered Aviation Inc · Rogers, ARN72JAOtter Air LLC · Fishers, INN72KGM & P Aviation LLC · Byhalia, MSN73TBMagic Leasing LLC · Peotone, ILN740CAHyannis Air Service Inc · Hyannis, MAN744BWDobson'S Leasing Co LLC · Ocoee, FLN747WSHyannis Air Service Inc · Hyannis, MAN74PBBaranko Peter A · Meridian, IDN751CAHyannis Air Service Inc · Hyannis, MAN754KCPlane Crazy Aviation LLC · Fargo, NDN75TTReisback Scott · Olalla, WAN763EAHyannis Air Service Inc · Hyannis, MAN764EAHyannis Air Service Inc · Hyannis, MAN764PBBisono Pablo R · Guaynabo, PRN769EAHyannis Air Service Inc · Hyannis, MAN771EAHyannis Air Service Inc · Hyannis, MAN775RCAirswiss Inc · Wilmington, DEN787DRBad Aire LLC · Aledo, TXN789PTValiair Limited Company · Casper, WYN78DGUsac 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, DEN79PPJon Gibson Co · Cameron Park, CAN800BAN8vv Inc · Corpus Christi, TXN802HLAir Hammer LLC · Wilmington, DEN805PRValiair Lc Trustee · Casper, WYN80JJZing Aviation And Marine LLC · New Smyrna, FLFirst renewal noticeN810BWHyannis Air Service Inc · Hyannis, MAN812SRVantage Point Northwest Aviation LLC · Sheridan, WYN818ANBank Of Utah Trustee · Salt Lake City, UTN824RBShark Water Systems LLC · Hobbs, NMN82AWQualitair LLC Trustee · MichelstadtN82DAAircraft Holding Solutions LLC Trustee · Newark, DEN82GLJusticia Holdings LLC · Roanoke, VAN831BMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN83DLake Placid Flying Service Inc · Lake Placid, NYN83PBHyannis Air Service Inc DBA · Hyannis, MAN84DAVoorhees Investments Inc · Costa Mesa, CAN84PRSkov Equipment Co · Fabens, TXN855HSanford Larry D · Edmond, OKN86AWMohave County Sheriff'S Office · Kingman, AZN86PDTanric Aviation LLC · Tuscola, TX
Back to AD 2005-12-13