AD 2012-06-01
Registered aircraft · 726
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:2012-06-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:2012-06-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:2012-06-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:2012-06-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.
N716LDDorf Air Leasing LLC · Saint Louis, MON717EHElkhart Holdings II LLC · Elkhart, INFirst renewal noticeN717NBMckenzie Bridge Land Co LLC · Bakersfield, CAN718QQExcel Aviation LLC · Saint Clairsville, OHN719TTZorair LLC · Houston, TXN71HCSoar20 LLC · Holmes, FLN720GBCloudkisser LLC · Marco Island, FLN720RWRkwilerrebel Mgt LLC · Las Vegas, NVN721RNAmd Leasing LLC · Kentwood, MIN721WRTpl Logistics LLC · Lubbock, TXN721XLAir Suz LLC · Memphis, TNN723JGFriends In The Skies LLC · Dallas, TXN724GTCoral One LLC · Orlando, FLN724MPCanary Holdings LLC · Lexington, KYN725MSBlue Doors Property Management LLC · Matthews, NCN725XLHogs Fly LLC · Crystal Lake, ILN727PJBlack Hat Ventures Pp LLC · Naples, FLN72SGAero Air Charter Holding LLC · Pensacola, FLN72XLGate Precast Co · Jacksonville, FLN731BPBank Of Utah Trustee · Salt Lake City, UTN735XLPjk Equipment Leasing LLC · Zelienople, PAN737DDegol Aviation Inc · Altoona, PAN746CXB Street Air LLC · Omaha, NEN746PCAerozephyr LLC · Long Beach, CAN748WRt Air II LLC · Little Rock, ARN749XLMitchco Air LLC · Louisville, KYN750BABklavi LLC · New Richmond, WIN75PSSnow Peak Ventures LLC · Spanish Fork, UTN75TPCrimson Excel LLC · Wilmington, DEN75XL5437 Holdings LLC · Houston, TXN760EDLimnes Aviation LLC · Hillsboro, ORN765KRSnp Ventures LLC · Kurten, TXN766CBNals Apartment Homes LLC · Ogden, UTN767BSBrewer Air LLC · Orwigsburg, PAN76SNMsn Enterprises LLC · Tulsa, OKN771DEDhb Aviation LLC · Smithfield, NCN771DGFuneral Directors Life Insurance Co · Abilene, TXN771PMTbn Group LLC · Reno, NVN777LXFrontenac Properties Inc · Chesterfield, MON777RBSchwik Air LLC · Springfield, ILN77DZZkd Air LLC · Houston, TXN77JDJd Capital LLC · Fort Smith, ARN781KBRipley Entertainment Inc · Orlando, FLN781SLBb & Ryder LLC · Conway, ARN785CC7 Highway Investors LLC · Leawood, KSN785TBSeven Eight Five Tb LLC · Topeka, KSN786TTXepa Air Inc · Pomona, CAN787TYLife Logistics LLC · Chesterfield, MON788TMT Air LLC · Birmingham, ALN789HUBmag Management Co LLC · Oklahoma City, OK
Back to AD 2012-06-01